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
caseif-statementsqlsql-servert-sql
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
Best Answer
The
CASE
statement is the closest to IF in SQL and is supported on all versions of SQL Server.You only need to use the
CAST
operator if you want the result as a Boolean value. If you are happy with anint
, this works:CASE
statements can be embedded in otherCASE
statements and even included in aggregates.SQL Server Denali (SQL Server 2012) adds the IIF statement which is also available in access (pointed out by Martin Smith):