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
-
1010 Avenue of the Moon
New York, NY 10018 US. -
Mon - Sat 8.00 - 18.00
Sunday: Closed - Get A Quote