=

Equal to

<

Less than

>

Greater than

<>

Not equal to

<=

Less than or equal to

>=

Greater than or equal to

*

Any number of characters (including none) may take the place of the asterisk (*)

?

Any one character matches the question mark (?)

IS NOT NULL

Searches for nonblank fields

IS NULL

Searches for blank fields

LIKE

Searches for values starting with the indicated string

NOT LIKE

Searches for values not starting with the indicated string

" "

Searches for strings that contain special characters, such as a comma (,)

EXISTS ( )

Searches for values in a multi-value group

[~]

Forces the case of the text string to whatever follows the tilde (~)