Case and Accent Insensitivity

If your SAP ASE 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 SAP ASE server:

where col_name like "Sm%"

If your SAP ASE 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.