Operator

Function

=  

The search item exactly matches the value entered.

not = 

The search item does not match the value entered.

starts with 

The search item starts with the value entered. The starts with operator cannot be used with date fields.

contains 

The search item contains the value entered. The contains operator cannot be used with date fields.

is one of 

The search item is one of many that is entered, or choose from a predefined list. Use the Lookup link to select from a list of available values for the field. To select values, click on the Lookup link.  Next, click in the checkbox(es) next to the value(s). If typing the values, separate the entries using a semicolon (;).

is not one of 

The search item is not one of many that you enter or choose from a predefined list.  Use the Lookup link to select from a list of available values for the field. To select values, click on the Lookup link.  Next, click in the checkbox(es) next to the value(s). If typing the values, separate the entries using a semicolon (;).

< 

The search item is less than the value entered.

> 

The search item is greater than the value entered.

<=

The search item is less than or equal to the value entered.

>=

The search item is greater than or equal to the value entered.