How can I convert this MySQL statement to MSSQL?
It is a simple IF statement that returns the first value if TRUE (1), and the second if FALSE (NULL)
I am using this with PHP so it is not to be placed in a function/procedure.
SELECT CASE WHEN VALUE = 5 THEN 1 ELSE NULL END
answered Jul 20 '10 at 09:44 PM