Replace substrings in a column

Hello!

Which UPDATE statement do I need to replace a substring in a column.

e.g.

old value = "\\ComputerA\Projects\aaa.txt" new value = "C:\Projects\aaa.txt"

substring "\\ComputerA" hast to be replaced by "C:"

Regards,
Robert Received on Fri Nov 18 2005 - 09:53:17 CST