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:

IN -> SqlServer_01.sql
SELECT IIF( 2 > 3, 'TRUE', 'FALSE' ) AS RESULT

Result:

RESULT|
------+
 FALSE|

Known Issues

No issues were found.

No related EWIs.

Last updated