Using wildcard symbols in the advanced search bar

When you specify search criteria to find requests, you can use wildcard symbols as shown in the following table to indicate one or more characters:

Wildcards

 In the advanced search bar, wildcard symbols are interpreted as wildcards only when used with the LIKE operator; otherwise, they are interpreted as explicit characters. You must use the percent symbol (%) when you want to include leading or trailing characters in your search. For example, if you want to find all requests submitted by Jill Bobbington, Bobby Fenton, and Bob Comptonson, enter the following text in the advanced search bar:

'Submitter' LIKE "%Bob%ton%"