BETWEEN Operator
The operator BETWEEN, tests whether the value lies in a specified series. That means "greater than or equivalent to low value and less than or equivalent to high value." For illustration, the expression below is false:
45 BETWEEN 38 AND 44