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.