CASE Contruct

SELECT CASE (case_expr)

CASE (case_selector)

block 1

CASE (case_selector)

block 2

CASE DEFAULT

block n

END SELECT

The case_selector can take one of four forms:

case_value Execute block if case_vaue == case_value

low_value: Execute block if low_value <= case_expr

:high_value Execute block if case <= high_value

low_value:high_value Execute block if low_value <= case_expr <= high_value

or it can be a list of any combination of these forms separated by commas.