Operator List Box

To build a filter interactively, select one filter operator from the Filter Operators table:

Table 41. Filter Operators

OperatorDescription

in

Enables you to select one or more conditions; for example, Region in United States and Europe selects the United States and Europe regions.

not in

Opposite of in; for example, Region not in United States selects all regions except for the regions that are part of the United States.

like

Enables you to use the wildcard characters, % and *, at the end of an expression to find data that matches the characters in the string that you typed. For example, if the database includes 100-10, 100-20, 100-30, 100-10-10, and 100-10-20, 100-10% returns 100-10, 100-10-10, and 100-10-20.

not like

Opposite of like; for example, if the database includes 100-10, 100-20, 100-30, 100-10-10, and 100-10-20, not 100-10% returns 100-20 and 100-30.

=

Equal to.

<>

Not equal to.

<

Less than.

<=

Less than or equal to.

>

Greater than.

>=

Greater than or equal to.