By default, searches look for results that start with the text entered in the search field. For example, searching the 'Last Name' field for Smith would return all of the records in which the last name starts with Smith, including Smith, Smithson, Smithlin and so on.
You can use wildcard characters to search for fragments of a record. You cannot use wildcards to search number fields.
The following table describes wildcard characters that you can use when searching:
Wildcard Character |
Description |
Example |
% |
Any string of zero or more characters. |
%son returns all results that ends with son J%M returns all results that begin with J and ending with M You can use the % symbol at the beginning, in the middle or at the end of a set of letters or numbers |
_ |
Any single character. |
_ean finds all four-letter words that end with ean, such as Dean and Sean. |
[ ] |
Any single character within the specified range [a-f] or set [abcdef]. |
[C-P]arsen finds all words ending with arsen and beginning with any single character between C and P, such as Carsen, Larsen and Karsen. |
[^] |
Any single character not within the specified range [^a-f] or set [^abcdef]. |
de[^l]% finds all words beginning with de and where the following letter is not l, such as dessert and demo but not delete. |
|
Hint Entering a 0 in the first date field of a range will filter the search to exclude anything in the past. For example, if you enter 0 in the Customer Services - Events|Search page's first 'Start Date' field only future events will be returned in the search results.:
|
