Operators and Wildcards for Query By Example

You can use operators and wildcards in Query By Example fields. Operators and wildcards work in alphanumeric fields only, not date fields.

Operators

This table describes the operators that you can enter in Query By Example fields.

Operator	Description
None (you enter only a value)	Character field: Starts with Number or date field: Equals
>	Greater than
<	Less than
>=	Great than or equal to
<=	Less than or equal to
and	And Note: You can use this operator only in conjunction with other operators, for example: >0 and <=1000.
or	Or

Here are a few things to know about the >, <, >=, and <= operators:

• Results are based on alphanumeric sort, in alphanumeric fields. For example, if you enter >=ABC, then ABC, ABD, ABCA, ACB, and BAC are matches, but not AB5 or AB.

• A space is considered part of the filter value. For example, if you enter >= ABC, then ABC and ABD are matches only if they're preceded with a space.

Wildcards

This table describes the Query By Example wildcards that you can use at the beginning, middle, or end of your entered value. All other symbols are ignored.

Wildcard	Description	Examples
*	Multiple characters	Entered Value: add* Matches: The word add and words beginning with add, such as address
_	Single character	Entered Value: exp_nse Matches: Words such as expense or expanse