When entering values for selection criteria, a single or combination of values may be entered. Enter a single item, a list of individual items (separated by commas), or a range of items (joined by a dash " - ").
The Universal Match Symbol "@" may be used in two manners:
-
If the "@" precedes an actual value, the "@" implies any character in that position (e.g., @2).
-
If the "@" appears at the end of an entered value, the "@" implies any character in that and succeeding positions (e.g., 2@).
The following examples illustrate the various combinations.
|
Selection Criteria |
Results |
|---|---|
|
TEMP001 |
Character-for-character match (TEMP001 only) |
|
TEMP001@ |
Every entry that starts with the partial value entered (TEMP001, TEMP0011, TEMP0012, etc.) |
|
T@,W-Z@ |
Entries that begin with the partial value entered, plus entries within the specified range of partial values (all entries that begin with T, W, X, Y, or Z) |
|
T-Z |
Entries that fall within the specified range (all entries that begin with a T, U, V, W, X, Y, and if Z, by itself, exists as an entry) |
|
T-Z@ |
Entries that fall within the specified range (all entries that begin with a T, U, V, W, X, Y, or Z) |
|
W-Z |
Entries that fall within the specified range, except for the criteria after the exclude statement (all entries that begin with a W, X, or Z) |
|
@ |
Entries with a "2" in the third position (102345, AB2, AB2CD, etc.) |
|
exA-B |
All entries except those beginning with A, B, or W. |
When selecting a value that contains a comma or dash, that value must be enclosed in quotation marks ("). E.g., "Smith, Ann" or "A-B Enterprises, Inc."