Example
SQL Server 2012
Returns one of two values, depending on whether a given Boolean expression evaluates to true or false.
Parameters:
boolean_expressionevaluated to dtermine what value to returntrue_valuereturned ifboolean_expressionevaluates to truefalse_valuereturned ifboolean_expressionevaluates to false
SELECT IIF (42 > 23, 'I knew that!', 'That is not true.') AS iif_result
iif_result
------------
I knew that!
SQL Server 2012
IIF may be replaced by a CASE statement. The above example my be written as
SELECT CASE WHEN 42 > 23 THEN 'I knew that!' ELSE 'That is not true.' END AS iif_result
iif_result
------------
I knew that!
