=

Placed before a value, returns records containing a value equal to the query value.

<

Placed before a value, returns records containing a value less than the query value.

>

Placed before a value, returns records containing a value greater than the query value.

<>

Placed before a value, returns records containing a value that is not equal to the query value.

<=

Placed before a value, returns records containing a value less than or equal to the query value.

>=

Placed before a value, returns records containing a value greater than or equal to the query value.

*

Wildcard that can be placed in the middle, or at the beginning or end of a text string.

!

Used for negation.

""

Surrounds a string that, unless modified by a wildcard, must be matched exactly.

\

Escape symbol is used when double quotes should not be processed as a special symbol. For example, !("*null text"or(\"*\")) is a value expression for a text field. The query returns values that do not end with a string null text and that are not surrounded by double quotes.

()

Surrounds the values and operators that will be processed first.

NULL

Returns records for which the query field is blank.

AND

Placed between values, returns only records for which all the given conditions are true. (Not case sensitive.)

OR

Placed between values, returns records for which at least one condition is true. (Not case sensitive.)