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.
|
|
View this book as PDF