IIF()

Ternary conditional function

Result type

Depends on input

Syntax

IIF (<condition>, ResultT, ResultF)

Table 1. `IIF` Function Parameters
Parameter	Description
condition	A true\|false expression
resultT	The value returned if the condition is true
resultF	The value returned if the condition is false

IIF takes three arguments.If the first evaluates to true, the second argument is returned;otherwise the third is returned.

IIF could be likened to the ternary “<condition> ? resultT : resultF” operator in C-like languages.

Note	`IIF(<condition>, resultT, resultF)` is a shorthand for “`CASE WHEN <condition> THEN resultT ELSE resultF END`”.