Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Remove letters with accents ex:ã

Author  Topic 

mike13
Posting Yak Master

219 Posts

Posted - 2013-02-03 : 12:34:13
Hi all,

Is there a way to remove ã and turn it into a ?
ex: joão into joao

Thanks a lot,
Mike

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-02-03 : 18:42:38
I don't know any generic way to replace the accented characters with non-accented, if there indeed is one in T-SQL. You can of course, do it the hard way, which I probably don't need to tell you about:
REPLACE('joão','ã','a')
Go to Top of Page
   

- Advertisement -