Using not like  Using wildcard characters

Chapter 4: Expressions, Identifiers, and Wildcard Characters

Case and accent insensitivity

If your Adaptive Server uses a case-insensitive sort order, case is ignored when comparing expression and match_string. For example, this clause would return “Smith,” “smith,” and “SMITH” on a case-insensitive Adaptive Server:

where col_name like "Sm%"

If your Adaptive Server is also accent-insensitive, it treats all accented characters as equal to each other and to their unaccented counterparts, both uppercase and lowercase. The sp_helpsort system procedure displays the characters that are treated as equivalent, displaying an “=” between them.





Copyright © 2005. Sybase Inc. All rights reserved. Using wildcard characters

View this book as PDF