Share this page

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)

hourly_rate <= 50)