CASE
A case expression evaluates a list of conditions and returns a result expression.
CASE has two formats:
• The simple CASE function compares an expression to a set of simple expressions to determine the result.
• The searched CASE function evaluates a set of Boolean expressions to determine the result.
Both formats support an optional ELSE argument.
