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 will receive a syntax error.
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. |
|
|
