Case and accent insensitivity  The percent sign (%) wildcard character

Chapter 4: Expressions, Identifiers, and Wildcard Characters

Using wildcard characters

You can use the match string with a number of wildcard characters, which are discussed in detail in the following sections. Table 4-7 summarizes the wildcard characters:

Table 4-7: Wildcard characters used with like

Symbol

Meaning

%

Any string of 0 or more characters

_

Any single character

[ ]

Any single character within the specified range ([a-f]) or set ([abcdef])

[^]

Any single character not within the specified range ([^a-f]) or set ([^abcdef])

Enclose the wildcard character and the match string in single or double quotes (like “[dD]eFr_nce”).





Copyright © 2005. Sybase Inc. All rights reserved. The percent sign (%) wildcard character

View this book as PDF