Operator

Description

=

Equal to

< >  OR  !=

Not equal to

> 

Greater than

< 

Less than

>=

Greater than or equal to

<=

Less than or equal to

AND

Both conditions must be satisfied

OR

Either condition must be satisfied

BETWEEN

Range comparison

TRUE

Is TRUE

FALSE

Is False