I was think something more like:
Update Table set field = STRTRAN(field,"\\Server\OldShare\Folder\","\\Server\NewShare\")
Not sure about the syntax for SQL Server
>
>UPDATE YourSqlTable SET YourTableField = '\\Server\NewShare\...'
>
>>I have a table with a field that stores file locations.
>>
>>I would like to move the files that are referenced in that field so I need to update the field with the new location.
>>
>>The files are stored in \\Server\OldShare\Folder\...
>>
>>and I want to move them to \\Server\NewShare\...
>>
>>Is there a single UPDATE statement that can handle this?