dynamic update

[chrisleon]

I am not sure how to do this or if it is even possible.

I have this type of data in a column

PATH
I:\IMAGES\GROUP955
I:\IMAGES\GROUP956
I:\IMAGES\GROUP957
I:\IMAGES\GROUP958
I:\IMAGES\GROUP959

I need to run an update to this column and change the drive mapping to the unc path ie \servername\share\ where it is equal to I:\

But the problem is the unique GROUP folder numbers. Is there a way to do this for the whole column dynamically, or am I running individual updates on each row?

[cahva]

You would use REPLACE function in your query. Eg.:

UPDATE table SET path=REPLACE(path,'I:\','\\servername\share\')