Hello: I have a table that has a field called attachFilename

currently, all the records are poulated for this field with a string such as "\\companydrive\g-drive\company_TEST\Job_12\Job_12.dwg"

and I need to replace this portion of the string: "\\companydrive\g-drive\company_TEST" with a different string.

Is there an easy way to do this with sql?

I'm using sql express 2008.

thanks,
Proctor