CASE statement v16

The CASE statement executes a set of one or more statements when a specified search condition is TRUE. The CASE statement is a standalone statement while the CASE expression must appear as part of an expression.

The two formats of the CASE statement are a searched CASE and one that uses a selector.

selector_case_statement searched_case_statement