The BETWEEN condition can evaluate to TRUE, FALSE, or UNKNOWN. Without the NOT keyword, the condition evaluates as TRUE if
expression is between start-expression and end-expression. The NOT keyword reverses the meaning of the condition, but leaves UNKNOWN unchanged.
The BETWEEN condition is equivalent to a combination of two inequalities:
[ NOT ] ( expression >= start-expressionANDexpression <= end-expression )