Operator

Description

>, <, >=, <=, <>

Standard boolean operators for a comparison test.

LIKE

Adds a LIKE clause to the query. Tests whether the data matches the specified pattern.

NOT LIKE

Adds a NOT LIKE clause to the query. Tests whether the data value does not match the specified pattern.

IN

Adds an IN clause to the query. Tests whether the data matches at least one value in the list of values. To create this list of values, enter fields and/or values separated by commas into the second Field or Value column.

NOT IN

Adds a NOT IN clause to the query. Tests whether the data does not match any value in the list of values. To create this list of values, enter fields and/or values separated by commas into the second Field or Value column.

BETWEEN

Adds a BETWEEN clause to the query. A BETWEEN clause tests whether the field or value falls within a specified range of values. For example, you can use this to return the salespeople whose sales are between $50,000 and $200,000.

NOT BETWEEN

Adds a NOT BETWEEN clause to the query. A NOT BETWEEN clause tests whether the field or value is outside a specified range of values.

IS NULL

Adds an IS NULL clause to the query. Tests whether the field or value contains a NULL value.

IS NOT NULL

Adds an IS NOT NULL clause to the query. Tests whether the field or value does not contain a NULL value.