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) |
|
> |
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 |