4. Elements of OpenSQL Statements : Predicates : Between Predicate
 
Share this page                  
Between Predicate
The following table explains the operators between and not between:
Operator
Meaning
y between x and z
x < = y and y < = z
y not between x and z
not (y between x and z)
x, y, and z are expressions and cannot be subqueries.