The percent (%) wildcard can be used in parameters that allow wildcard-character search patterns. This wildcard represents any string of zero or more characters.
If the percent (%) character is used in parameters that do not allow wildcard-character search patterns, the DB2 access service rejects the character and issues an error message.
The following table 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 |
Copyright © 2005. Sybase Inc. All rights reserved. |
![]() |