How to replace a string in a SQL Server Table Column

sql sql-server database database-administration
Iralda Mitro picture Iralda Mitro · May 2, 2009 · Viewed 800.3k times · Source

I have a table (SQL Sever) which references paths (UNC or otherwise), but now the path is going to change.

In the path column, I have many records and I need to change just a portion of the path, but not the entire path. And I need to change the same string to the new one, in every record.

How can I do this with a simple update?

Answer

cjk picture cjk · May 2, 2009

It's this easy:

update my_table
set path = replace(path, 'oldstring', 'newstring')

Related questions

How to change database from Single user mode to multi user

I have a Database,Which is in Single user mode ,If i want to access a tables in the database i will be changing in the properties from single to multiuser.How can i make the Database multi user permenantly?.

Read More
Reset identity seed after deleting records in SQL Server

I have inserted records into a SQL Server database table. The table had a primary key defined and the auto increment identity seed is set to “Yes”. This is done primarily because in SQL Azure, each table has to have …

Read More
How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More