The conditional expressions described in this section are building blocks for creating expressions that convert a value from one form to another.
Notes:
In CASE
statements, AND
has precedence over OR
.
Strings must be a single quotes.
Expression | Example | Description |
---|---|---|
CASE (If) |
CASE WHEN score-par < 0 THEN 'Under Par' WHEN score-par = 0 THEN 'Par' WHEN score-par = 1 THEN 'Bogie' WHEN score-par = 2 THEN 'Double Bogey' ELSE 'Triple Bogey or Worse' END |
Evaluates each WHEN condition and if satisfied, assigns the value in the corresponding THEN expression.
If none of the |
CASE (Switch) |
CASE Score-par WHEN -5 THEN 'Birdie on Par 6' WHEN -4 THEN 'Must be Tiger' WHEN -3 THEN 'Three under par' WHEN -2 THEN 'Two under par' WHEN -1 THEN 'Birdie' WHEN 0 THEN 'Par' WHEN 1 THEN 'Bogey' WHEN 2 THEN 'Double Bogey' ELSE 'Triple Bogey or Worse' END |
Also referred to as CASE (Lookup) . The value of the first expression is examined, then the WHEN expressions. If the first expression matches any WHEN expression, it assigns the value in the corresponding THEN expression.
If none of the If the first expression matches an expression in multiple |