SQLite IIF() Function

The SQLite IIF() function returns a value if a condition is TRUE, or another value if a condition is FALSE.

Syntax

IIF(condition, value_if_true, value_if_false)

Parameters

`condition`	`Required.` Specify the value to test.
`value_if_true`	`Required.` Specify the value to return if condition is TRUE.
`value_if_false`	`Required.` Specify the value to return if condition is FALSE.

Return Value

Returns value based on the condition.

Example 1:

The example below shows the usage of IIF() function.

SELECT IIF(100>200, "TRUE", "FALSE");
Result: "FALSE"

SELECT IIF(100<200, "T", "F");
Result: "T"

SELECT IIF(100<200, 500, 600);
Result: 500

SELECT IIF(DATE(NULL), 500, 600);
Result: 600

SELECT IIF('', 500, 600);
Result: 600

Example 2:

Consider a database table called Sample with the following records:

Data	x	y
Data 1	10	8
Data 2	20	22
Data 3	30	31
Data 4	40	39
Data 5	50	53

The below query is used to compare records of column x and y. Based on the comparison, the result is recorded.

SELECT *, IIF(x > y, "TRUE", "FALSE") AS IIF_Value FROM Sample;

This will produce the result as shown below:

Data	x	y	IIF_Value
Data 1	10	8	TRUE
Data 2	20	22	FALSE
Data 3	30	31	FALSE
Data 4	40	39	TRUE
Data 5	50	53	FALSE

❮ SQLite Functions