Assignment Operators

Assignment operators define the criteria that the filter uses to search fields in a database for specific values. Each condition statement in a filter must contain one assignment operator.

The following assignment operators are available when creating custom filters.

Option

Description

Equals

The value in the specified field must match the entered value.

Does not equal

The value in the specified field must not match the entered value.

Is greater than

The value in the specified field must be greater than the entered value.

Is greater than or equal to

The value in the specified field must be greater than or equal to the entered value.

Is less than

The value in the specified field must be less than the entered value.

Is less than or equal to

The value in the specified field must be less than or equal to the entered value.

Is between

The value in the specified field must be between the two entered values.

Is not between

The value in the specified field must not be between the two entered values.

Is blank

The specified field must not contain any data.

Is not blank

The specified field must contain data.

Is any of

The value in the specified field must be equal to any of the identified values. Click the icon to add additional values.

Is none of

The value in the specified field must not be equal to any of the identified values. Click the icon to add additional values.

Begins with

The value in the specified field must begin with the entered letter(s) or numbers(s).

Ends with

The value in the specified field must end with the entered letter(s) or numbers(s).

Contains

The value in the specified field must contain the entered string of letter(s) or numbers(s).

Does not contain

The value in the specified field must not contain the entered letter(s) or numbers(s).

Is like

The value in the specified field must be similar to the entered value.

Is Not Like

The value in the specified field must not be similar to the entered value.