Remove accent/special characters in columns in SQL

Question

Is there anyway we can remove the accent in columns?

Example: per_names table has following column names:

Name
Arévalo
Chère

I want this column to have values as follows:

Name
    Arevalo
    Chere

Is this possible ?

Answer 1

You can try using the translate command..

TRANSLATE(data,'ÁÉáéÑ','AEaeN') 

That will map: Á to A, É to E, á to a, é to e, Ñ to N. Just keep adding the characters you need to map more