Using Wildcards
The wildcard character, which is the percent (%) character, represents zero or more characters. Thus, for example, the search string ABC%DEF finds all strings that begin with ABC and end with DEF, with any number of characters in between. The search string ABC%DEF% finds all strings that begin with ABC and include DEF anywhere else. If you do not include a wildcard character in the search string, the search assumes that there is a wildcard character at the end of the search string, unless the find qualifier EXACT_NAME_MATCH is specified. Thus, for example, if you specify ABC as the search string, the search in fact looks for and finds strings that match the pattern ABC%, that is, all strings that begin with the characters ABC.