IF - Firebolt Documentation

Evaluates a condition and returns different results based on whether the condition is true or false. The IF function is a simplified alternative to the CASE expression for handling conditional logic.

Syntax

IF(<condition>, <then>, <else>)

Parameters

Parameter	Description	Supported input types
`<condition>`	Condition that the function evaluates.	`BOOLEAN`
`<then>`	Value returned when `<condition>` evaluates to `true`.	Any
`<else>`	Value returned when `<condition>` evaluates to `false` or `NULL`. Must match the data type of `<then>`.	Any

Return type

The IF function returns the same data type as the <then> and <else> parameters.

Example

The following example classifies each level in the levels table as 'Hard' when its maxpoints score threshold is 100 or above, and 'Easy' otherwise:

SELECT level, name, IF(maxpoints >= 100, 'Hard', 'Easy') AS difficulty
FROM levels
ORDER BY level;

level int null	name text null	difficulty text
1	Thunderbolt Circuit	Easy
2	Velocity Vale	Easy
3	Raceway Ridge	Easy
4	Nitro Narrows	Hard
5	Thunder Road	Hard
6	Burnout Boulevard	Easy
7	Speed Street	Easy
8	Racing Ravine	Hard
9	Drift District	Hard
10	Acceleration Alley	Hard

Rows: 10Execution time: 6.00ms

HASH

IFNULL

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

IF

Syntax

Parameters

Return type

Example

​Syntax

​Parameters

​Return type

​Example

Syntax

Parameters

Return type

Example