BETWEEN

BETWEEN returns a bit(1) value that indicates whether x is in the closed interval as defined by a and b.

Read syntax diagramSkip visual syntax diagramBETWEEN( x, a, b)
x, a, and b
Expressions. They must be either all ORDINAL with the same type or all computational.

BETWEEN(x,a,b) is equivalent to the test (a <= x) & (x <= b). Thus, if any of the arguments are numeric, they must all be REAL.

In BETWEEN(x,a,b), a <= b must be true, and if not, the program is in error and its behavior is undefined.