remove and replace accents function

does anyone know where i can find a user defined function that replaces accented characters with their normal ones

i want to replace all accented characters since for some reason sql server does not store the characters properly, or when they exported to excel for html they are displayed incorrectly

thanksCome again?

Got an example?|||does anyone know where i can find a user defined function that replaces accented characters with their normal ones

thanks

REPLACE?

FROM SQL BOL:
REPLACE (string1, string2, string3)

SELECT REPLACE('abcdefghicde','cde','xxx')
GO

(no column name)
abxxxfghixxx|||Can you just force an Accent-Insensitive collation for the comparison? This is lots faster, easier, and more reliable than trying to "skin the string" yourself.

Brett: What they want is to convert any of (, , , , , ) into A. There are lots of letters, and some strange conversion rules. A collation change is easy, standard, and reliable.

-PatP|||Why Do people use other than out of the box collation?

I mean, I know there are certain situations...but I haven't seen one where it's been needed.

I love when they set up case sensitive...

Thanks for coming up for some air....