How to remove diacritics in SQL Server

The easiest way to remove diacritics from a string in SQL Server is to collate the string using a character set that does not include diacritics, such as :

SELECT 'àéêöhello!' Collate SQL_Latin1_General_CP1253_CI_AI

This will output :

aeeohello!

This work only if you are not using a unicode string, so cast it as varchar first if you have a unicode string.