In article <ug8ub.4379$zz.1972696130@newssvr30.news.prodigy.c om>,
jerry@antech.biz.nospam says...
> You could use the REPLACE function.
>
> UPDATE mpTable SET myNewColumn = REPLACE(myOriginalColumn, 'A\BO', 'A\C-B0')

I like it. I'm a little confused, though. Don't I need a WHERE clause?

-- Rick