SELECT Statement QuickSCREEN
◄QuickSCREEN► ◄Details► ◄Example► ◄Contents► ◄Index►
──────────────────────────────────────────────────────────────────────────────
SELECT CASE - a control flow statement that executes one of several
statement blocks depending on the value of an expression
Syntax
SELECT CASE testexpression
[CASE expressionlist1]
[statementblock-1]
[CASE expressionlist2
[statementblock-2]] ...
[CASE ELSE
[statementblock-n]]
END SELECT
■ testexpression is any numeric or string expression.
■ expressionlist contains one or more expressions of the same type as
testexpression. The IS keyword must precede any relational operators
in an expression.
■ statementblock consists of any number of statements on one or more
lines.