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