Wildcard Search

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

·            Advanced Search

·            Unified Search