I want to replace characters like á, à, Â or è, é, basically those with accents or special characters, with the same letter but without the accent. Is there any function other than replace to do this in a more optimal and faster way?

I have tried with this but doesn’t work:

COLLATE SQL_Latin1_General_Cp1251_CS_AS