You can use wildcard characters if you do not know all the search information. Each wildcard character serves a different function.
For a video demonstration, refer to Search Functionality Video Demo.
Wildcard searches include the following:
Character |
Followed By. . . |
Example |
---|---|---|
Percent symbol (%) |
Any string of zero or more characters. |
For example, if you know a client’s last name begins with a “Ge,” enter “Ge%” in the Last Name field and click Search. All of the clients/customers whose last names begin with “Ge” are returned. |
Underscore (_) |
Any single character. |
For example, entering “Sm_th” would return both Smith and Smyth, but not Smooth. The underscore is especially helpful when searching for batches. |
Brackets ([ ]) |
Any single character within the specified range “[a-f]” or set “[abcdef]”. |
For example, entering “[CK]ars[eo]n” would return Carson, Carsen, or Karson.
|
Brackets with caret ([^]) |
Any single character not within the specified range “[^a-f]” or set “[^abcdef]”. |
For example, entering “De[^l]%” would return strings beginning with “De”, but not “Del”.
|
These characters are applicable when using SQL. If you use Oracle, the percent and underscore characters work, but not the brackets.
See Also:
· Overview: Search-Based Screens