How do I perform an IF...THEN
in an SQL SELECT
statement?
For example:
SELECT IF(Obsolete="N" OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product
How do I perform an IF...THEN
in an SQL SELECT
statement?
For example:
SELECT IF(Obsolete="N" OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product