Insert Text into column

[obryant32]

OK, so I'm not sure how to go about this. I have a column in one of my tables that stores the URL to a file that is saved on the hard drive. We then use that value to display a link to the file within our application. We recently copied all the files that have been uploaded into our system to a new server and now we need add another switch to the URL in every record

SO, let's say the current value is

http://www.app.com/test/file.pdf

I need it to be

http://www.app.com/new-test/test/file.pdf

So I need to add the "/new-test" switch to every url record in that column in that particular table.

Is there a way to write an update statement that will add the switch?

Thanks,
Matt

 

[SQLDenis]

update table set field =replace(field,'

http://www.app.com/','http://www.app.com/new-test/')

you could leave out the http stuff also, like this

update table set field =replace(field,'app.com/','app.com/new-test/')

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[gmmastros]

Maybe you can use the replace function to your advantage.

Select Replace('

http://www.app.com/test/file.pdf',

'

http://www.app.com',

'

http://www.app.com/new-test')

Basically, replace

http://www.app.com

with

http://www.app.com/new-test

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom