Coding instructions  Escape character

Chapter 6: Using Stored Procedures

Wildcard-character search patterns

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.

The following table shows some examples of the percent (%) wildcard character and its use:

Table 6-1: Wildcard character examples

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. Escape character

View this book as PDF