A CASE statement or IF statement.
You can specify these options for condition statements:
- CASE
- Keyword introducing the CASE conditional statement to qualify control statements.
- operand_2
- Value expressions or arithmetic and string expressions.
- THEN
- ELSE
- Keywords introducing the statements to be performed in the CASE statement.
- statement
- A valid SQL statement or SQL control statement.
- conditional_expression
- A boolean search condition used to evaluate whether to run a statement or statements embedded within an IF, CASE, REPEAT, or WHILE clause.
- END CASE
- Keywords marking the end of a CASE statement.
- IF
- Keyword introducing a conditional expression to qualify SQL control statements.
- ELSE
- ELSEIF
- A keyword introducing the THEN, ELSE, or ELSEIF clause in an IF statement.
- END IF
- Keywords marking the end of the IF statement.