Numeric Comparisons
Numeric constants do not have to be enclosed in quotes. The following example requires that the number entered in the Salary field be larger than zero:
salary > 0
This example requires that the number entered in the Age field be larger than or equal to 18 and less than or equal to 70:
age >= 18 AND age <= 70
A complex numeric expression must be enclosed in parentheses to clarify the way the expression must be evaluated.
The following example requires that the number entered in the Hourly_rate field either equal 30 or fall within the range of 40 to 50:
hourly_rate = 30 OR (hourly_rate >= 40 AND
hourly_rate <= 50)