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

Question

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

Answer 1

You need the CASE statement:

SELECT

CASE

WHEN

(Obsolete='N' or InStock='Y')

THEN 1

ELSE 0

END AS Saleable, *

FROM Product