Remove "Accents" in a SQL Query

[storm197]

Hi,

I want to know if there is a function in SQL that enable to remove accent from a field (example, convert é,è ou ê to e)

If not, is there a mean to do that ?

Thank you

 

[dbomrrsm]

Look at REPLACE in BOL

DBomrrsm

[blue]DBomrrsm[/blue]

 

[storm197]

Ok, it's working! If I put the following line, it works for the é :

SELECT REPLACE (GPM_E_ELE.nom,"é",'e')
FROM GPM_E_ELE;

But is there a mean to put multiple value in it (é, è or ê for example).

I'm really newbie at this.

 

[dbomrrsm]

Dont think REPLACE aloows multiple values - sorry.

DBomrrsm

[blue]DBomrrsm[/blue]

 

[SQLBill]

You would have to do it as multiple REPLACEs.

SELECT REPLACE (GPM_E_ELE.nom,'é','e'),
       REPLACE(GPM_E_ELE.nom, 'è', 'e'),
       REPLACE(GPM_E_ELE.nom, 'ê', 'e')
FROM GPM_E_ELE;

-SQLBill