◄Syntax►  ◄Details►  ◄Example►                 ◄Contents►  ◄Index►  ◄Back►
──────────────────────────────────────────────────────────────────────────────
SELECT CASE testexpression
CASE expressionlist1
  [statementblock-1]
[CASE expressionlist2
  [statementblock-2]]...
[CASE ELSE
  [statementblock-n]]
END SELECT
 
    ■ testexpression    Any numeric or string expression (see Details).
    ■ expressionlist    One or more expressions with a type compatible
                        with testexpression. The IS keyword must precede
                        any relational operators in an expression.
    ■ statementblock    Any number of statements on one or more lines.