Re: Replace substrings in a column

In article <f14d4$437df8b7$d4badae4$30839_at_news.chello.at>, Robert Wehofer says...
> 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:"
>

update tab
set col = replace(col,'string1','string2') where ....

-- 

jeremy