CASE
Goes through conditions in sequence and returns the value of the result associated with the matching condition.
Syntax 1
Parameters
Parameter | Description |
---|---|
condition | An expression that evaluates to a BOOLEAN value. |
result | A value or an expression that evaluates to a value. The CASE expression returns result if its associated condition evaluates to true. |
Returns
- The result associated with the first condition that evaluates to true. Or,
- The result in the ELSE clause if no condition evaluates to true. Or,
- NULL if there is no ELSE clause and no condition evaluates to true.
Syntax 2
Parameters
Parameter | Description |
---|---|
expression | An expression that evaluates to a value. expression is computed in the first place and its value will be compared with value in the WHEN clause. |
value | A value or an expression that evaluates to a value. Each value is a potential match for the expression. |
result | A value or an expression that evaluates to a value. The CASE expression returns result if its associated value matches the expression. |
Returns
- The result associated with the first value that matches the expression. Or,
- The result in the ELSE clause if no value matches the expression. Or,
- NULL if there is no ELSE clause and no value matches the expression.