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.
