Symbol

Condition

Example

=

Equal to

Enter New York for the City attribute to retrieve all customers located in "New York".

<>

Not equal to

Enter <>New York for the City attribute to retrieve all customers located outside of "New York".

%

Any value

Zero or more characters without limitations

Enter New% for the City attribute to retrieve all customers located in a city beginning with "New" (New York, New Orleans etc.).

!%

No value

Specify !% for the City attribute to retrieve all customers for which city has not been specified.

_

Any character

Single character without limitations. Enter _e% for the City attribute to retrieve all customers located in a city with an "e" as the second character.

>

Larger than

Enter >100 for the Customer ID attribute to retrieve all customers with an ID greater than "100".

<

Less than

Enter <100 for the Customer ID attribute to retrieve all customers with an ID less than "100".

>=

Larger or equal to

Enter >=100 for the Customer ID attribute to retrieve all customers with an ID greater than or equal to "100".

<=

Less or equal to

Enter <=100 for the Customer ID attribute to retrieve all customers with an ID less than or equal to "100".

+

Checked

Enter + in the Valid field to retrieve all customers for which the valid check box has been checked.

-

Unchecked

Enter - in the Valid field to retrieve all customers for which the valid check box has not been checked.

..

Between

If you want to include values 5, 6, 7, 8, 9, 10, the condition would be 5..10.

;

Or

Specify New York; Philadelphia for the City attribute to retrieve all customers located either in "New York" or "Philadelphia".