The percent (%) wildcard character can be used in parameters that allow wildcard-character search patterns. This wildcard represents any string of zero or more characters. When using CSPs, the wildcard expression must be enclosed in quotation marks.
If the percent (%) character is used in parameters that do not allow wildcard-character search patterns, you receive a syntax error.
Table 4-1 shows some examples of the percent (%) wildcard character and its use:
Sample string |
Matches |
---|---|
“%A%” |
All names that contain the letter “A,” for example, A, AT, CAT |
“%” |
All names |