8. SQL Statements : IF - THEN - ELSE : Syntax
 
Syntax
The IF-THEN-ELSE statement has the following format:
IF boolean_expr THEN statement; {statement;}
              {ELSEIF boolean_expr THEN statement; {statement;}}
              [ELSE statement;{statement;}]
ENDIF