How to remove special characters from a string completely in sql server

Question

update myTable set Column = REPLACE(Column,'₦', '')
I tried to remove the naira with the above command but it's not just working for me.

Possible duplicate of [How to strip all non-alphabetic characters from string in SQL Server?](http://stackoverflow.com/questions/1007697/how-to-strip-all-non-alphabetic-characters-from-string-in-sql-server) — Igor Quirino, Dec 22 '16 at 19:50

John Cappelletti · Answer 1 · 2016-12-22T18:56:10.640

2

Update myTable set [Column] = REPLACE([Column],N'₦', '')  -- Assuming nvarchar()

You should try to avoid Reserved Words.

edited Dec 22 '16 at 18:56

answered Dec 22 '16 at 18:50

John Cappelletti

score 0 · Answer 2 · answered Dec 22 '16 at 19:22

0

UPDATE Dummy set myColumn = replace(myColumn,'abc','xyz');

where abc is character that you want to remove from mycolumn and xyz is substring that u want to replace with the special character

answered Dec 22 '16 at 19:22

2 Answers2