Between
The Between operator defines a range of numbers similar to using to >= and <=. The range is inclusive of the two numbers you indicate.
Syntax: Between number1 and number2
-
Number1 is the low number.
-
Number2 is the high number.
Example: When you set the range between 5 and 10, the query searches for the numbers 5, 6, 7, 8, 9, and 10.