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

update myTable
set Column = REPLACE(Column,’₦’, ”)

I tried to remove the naira with the above command but it’s not just working for me.

  • SQL Server Authentication or Integrated Security?
  • How to list out all Foreign Keys with “WITH NOCHECK” in SQL Server
  • LINQ Using ROW_NUMBER() function?
  • SQL Server: datediff function resulted in an overflow when using MILLISECOND
  • Insert Percentage Symbol in SQL server
  • How can I batch update this?
  • 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.

    https://msdn.microsoft.com/en-us/library/ms189822.aspx

    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

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.