How to remove diacritics (accents) from words in SQL Server

Select 'à éêöhello!' Collate SQL_Latin1_General_CP1253_CI_AI

Create Function [String].[RemoveDiacritics] ( @p_String Varchar(Max) )

Returns Varchar(Max) As

Begin

  Return @p_String Collate SQL_Latin1_General_CP1253_CI_AI;

End