MS SQL

Howto | mssql seach and replace?

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Aug 2006

Posts: 59

Reputation: desiguru is an unknown quantity at this point

Solved Threads: 1

desiguru

Offline

Junior Poster in Training

Howto | mssql seach and replace?

Nov 29th, 2006

In my database, I have two tables: Forum and Files

Files have two fields. First one is FileID and second one is FileAddress.

FileId field is fine. but in FileAddress field I have a lot of urls. I want to just change certain parts of url. For example, instead of having http://ipaddress/FILEPATH

I want to chage that to http://domain.com/FILEPATH for about 400 data in the sql table. How do I do this?????

•

Join Date: Jun 2006

Posts: 7

Reputation: RobStocks is an unknown quantity at this point

Solved Threads: 0

RobStocks

Offline

Newbie Poster

Re: Howto | mssql seach and replace?

Jan 15th, 2007

•

Originally Posted by desiguru

In my database, I have two tables: Forum and Files

Files have two fields. First one is FileID and second one is FileAddress.

FileId field is fine. but in FileAddress field I have a lot of urls. I want to just change certain parts of url. For example, instead of having http://ipaddress/FILEPATH

I want to chage that to http://domain.com/FILEPATH for about 400 data in the sql table. How do I do this?????

Hi Desiguru,
You could use the stuff function e.g.
stuff( 'http://ipaddress/FILEPATH', 8, 9, 'domain.com')
this will replace from character 8 the 9 characters 'ipaddress' with 'domain.com'
but you would obviously replace the string to be modified with the field name

stuff( FileAddress, 8, 9, 'domain.com')

and you would obviously need to select the appropriate records

Regards

Rob