Specifies an inclusive range, in which the lower value and the upper value and the values they delimit are searched for.
expression [ NOT ] BETWEEN start-expression AND end-expression
The BETWEEN condition can evaluate to TRUE, FALSE, or UNKNOWN. Without the NOT keyword, the condition evaluates as TRUE if expression is between start-expression and end-expression. The NOT keyword reverses the meaning of the condition, but leaves UNKNOWN unchanged.
The BETWEEN condition is equivalent to a combination of two inequalities:
[ NOT ] ( expression >= start-expression AND expression <= end-expression )
List all the products cheaper than $10 or more expensive than $15.
SELECT Name, UnitPrice FROM Products WHERE UnitPrice NOT BETWEEN 10 AND 15;
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|