IIF
Description
Returns one of two values, depending on whether the Boolean expression evaluates to true or false in SQL Server.(IIF in Transact-SQL).
Sample Source Pattern
Syntax
IIF( boolean_expression, true_value, false_value )
Examples
Code:
SELECT IIF( 2 > 3, 'TRUE', 'FALSE' ) AS RESULT
Result:
RESULT|
------+
FALSE|
Last updated