Comparison Operators

Type

Operator

Purpose

Comparison Operators are used to compare one value to another in record selection criteria, math formulas, and in other text and numeric expressions.

The DQL uses seven Comparison Operators:

• = Both sides of the comparison have the same value.

• < The value on the left side of the comparison is less than the value on the right side.

• > The value on the left side of the comparison is greater than the value on the right side.

• <= The value on the left side is less than or equal to the value on the right side.

• >= The value on the left side is greater than or equal to the value on the right side.

• between?..to The value lies within the specified range (inclusive).

• not Reverses the meaning of the operator that immediately follows it.

Examples

for MEMBERS with TOTAL DUE > 500

and STATE not = " NY " ;

for RESERVATIONS with RESERVATIONDATE between 06/01/95

to 06/31/95 ;