BETWEEN-predicate

The special BETWEEN predicate is available as a convenience.

Syntax

a BETWEEN x AND y

Semantics

a BETWEEN x AND y is equivalent to

a >= x AND a <= y

Similarly,

a NOT BETWEEN x AND y

is equivalent to

a < x OR a > y