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”.