Replace STRTRAN WITH REPLACE
Update Table set field = REPLACE(field,"\\Server\OldShare\Folder\","\\Server\NewShare\")
http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-MappingHTH
>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?
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst