Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


The BETWEEN Predicate


A BETWEEN predicate tests whether or not a value is within a range of values (including the given limits).

It has the form:

The BETWEEN predicate can always be expressed in terms of two basic predicates.

Thus:

Between predicate
Equivalent basic predicates
x BETWEEN a AND b
x >= a AND x <= b
x NOT BETWEEN a AND b
x < a OR x > b

All expressions in the predicate must have compatible data types.

The result of the predicate is unknown if the equivalent basic predicates give an unknown result.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Reference Manual TOC PREV NEXT INDEX