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