CASE value_expression_1 when_clause [...] [ ELSE scalar_expression_m ] END
Syntax Elements
- value_expression_1
- An expression whose value is tested for equality with value_expression_n.
- when_clause
WHEN value_expression_n THEN scalar_expression_n
- scalar_expression_m
- An expression whose value is returned if evaluation falls through to the ELSE clause.
- value_expression_n
- A set of expressions against which the value for value_expression_1 is tested for equality.
- scalar_expression_n
- An expression whose value is returned on the first equality comparison of value_expression_1 and value_expression_n.