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.