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.