How do I perform an IF…THEN in an SQL SELECT?

by

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

3
32

Leave a Comment