CASE WHEN

All functions > CONDITIONAL > CASE WHEN

Returns the result of the first condition that evaluates to true

Syntax

Diagram(
    Terminal("CASE"),
    OneOrMore(
        Sequence(
            Terminal("WHEN"),
            NonTerminal("condition"),
            Terminal("THEN"),
            NonTerminal("result")
        )
    ),
    Choice(0, Skip(),
        Sequence(Terminal("ELSE"), NonTerminal("default"))
    ),
    Terminal("END")
)

Notes

• Evaluates conditions in order and returns the first matching result
• If no condition matches and else is not provided, returns NULL
• Short-circuits: stops evaluating once a condition is true
• All then values and else value must be of compatible types

Related Functions

• CASE_WHEN