Wednesday, March 25, 2015

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, ' ', '_')




No comments:

Post a Comment