SQL Server find and replace specific word in all rows of specific column

In this example am gonna replace empty space with _

here is the code to do that :

UPDATE your_Table_Name
SET Column_Name = REPLACE(Column_Name, ' ', '_')




SQL Server find and replace specific word in all rows of specific column SQL Server find and replace specific word in all rows of specific column Reviewed by (C#) Csharp examples on 11:10 PM Rating: 5

No comments:

Facebook

Powered by Blogger.