Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Language Elements » Search conditions

ALL, ANY, and SOME search conditions Next Page

BETWEEN search condition

The syntax for the BETWEEN search condition is as follows:

expr [ NOT ] BETWEEN start-expr AND end-expr

The BETWEEN search condition can evaluate as TRUE, FALSE, or UNKNOWN. Without the NOT keyword, the search condition evaluates as TRUE if expr is between start-expr and end-expr. The NOT keyword reverses the meaning of the search condition but leaves UNKNOWN unchanged.

The BETWEEN search condition is equivalent to a combination of two inequalities:

[ NOT ] ( expr >= start-expr AND expr <= end-expr )