The percent sign (%) wildcard character  Bracketed ([ ]) characters

Chapter 4: Expressions, Identifiers, and Wildcard Characters

The underscore (_) wildcard character

Use the underscore ( _ ) wildcard character to represent any single character. For example, to find all six-letter names that end with “heryl” (for example, Cheryl):

select au_fname 
from authors 
where au_fname like "_heryl"



Copyright © 2005. Sybase Inc. All rights reserved. Bracketed ([ ]) characters

View this book as PDF