f1 [NOT] BETWEEN f2 AND f3 checks whether f1 is in the interval of f2 to f3, that is this expression is equivalent to f1 >= f2 AND f1 <= f3.
Checking Whether a Field Belongs to a Range