How to write a string search and replace SQL statement? 1

[texnut]

Hello all,

I have a database table that has about 400 or so URLs in it.

I have to change part of the string that makes up the URL.

Here is an existing URL string:
file://server1/share/file

I need to change this to:
file://server2/share/file

Anyone know how I can do this quickly using an SQL statement?

Thanks for any help on this!

 

[gmmastros]

Select Replace(URL, 'file://Server1/', 'file://Server2/') As NewURL
From   YourTable

If you need to do this permanently, and the above query returns the correct data, then you can update the table like this:

Update TableName
Set    URL = Replace(URL, 'file://Server1/', 'file://Server2/')

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[texnut]

gmmastros, thank you - it worked perfectly!