Matching a Range of Values

Restriction: This topic applies to Windows environments only.

You can specify a range of values that a column should satisfy using the BETWEEN predicate. Type the condition BETWEEN followed by a number, then the keyword AND, then another number. For example:

Between 2 and 8