=

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 non-blank 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 (~)