The BETWEEN
expression checks to see if the value
of a test expression is between a minimum expression and a
maximum expression, inclusive. The expression is logically
equivalent to (test >= min AND
test <= max)
, although the test
expression is only evaluated once. The BETWEEN
operator will return a logic value of
0
, 1
, or NULL
, under the rules of three valued
logic.