How to remove special characters from a string completely in sql server
set Column = REPLACE(Column,’₦’, ”)
I tried to remove the naira with the above command but it’s not just working for me.
2 Solutions collect form web for “How to remove special characters from a string completely in sql server”
Update myTable set [Column] = REPLACE([Column],N'₦', '') -- Assuming nvarchar()
You should try to avoid Reserved Words.
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