CASE when_clause [,...] [ ELSE scalar_expression_m ] END
Syntax Elements
- when_clause
WHEN search_condition_n THEN scalar_expression_n
- scalar_expression_m
- A scalar expression whose value is returned when no search_condition_n evaluates to TRUE.
- search_condition_n
- A predicate condition to be tested for truth.
- scalar_expression_n
- A scalar expression whose value is returned when search_condition_n is the first search condition that evaluates to TRUE.