That should do it, thanks.

>Replace STRTRAN WITH REPLACE
>

>Update Table set field = REPLACE(field,"\\Server\OldShare\Folder\","\\Server\NewShare\")
>

>http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping
>HTH
>
>>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?