To build a filter interactively, select one filter operator from the Filter Operators table:
Table 41. Filter Operators
Operator | Description |
---|---|
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. |