Update Column Data in Table

Hello everyone.

I have a table with four columns. One of these columns contains data about specific locations of items, which I need to change. I'd like to update the table, replacing all instances of the server share location with a different one.

I need to select "|\\server\folder1\folder2\folder3\document" and replace it with "|\\differentserver\folder1\folder2" etc.
Contemporary_CyberneticsAsked:
Who is Participating?
 
RiteshShahCommented:
will this work?

update tablename set replace(yourfiledname,'|\\server\folder1\folder2\folder3\document','|\\differentserver\folder1\folder2')
where server1='condition'
0
 
RiteshShahCommented:
you can check value by selecting it before executing update statement.

select replace(yourfiledname,'|\\server\folder1\folder2\folder3\document','|\\differentserver\folder1\folder2')
from tablename where server1='condition'
0
 
Contemporary_CyberneticsAuthor Commented:
Yep, I actually figured that out about 2 minutes ago. Thanks for the help, though.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.