In article <Htaub.826$xE6.230763650@newssvr11.news.prodigy.co m>,
jerry@antech.biz.nospam says...
> You could do this if you want...
>
> UPDATE mpTable SET myNewColumn = REPLACE(myOriginalColumn,
> 'A\BO', 'A\C-B0') Where myOriginalColumn LIKE '%A\BO%'

Thanks, Jerry. It worked great as originally posted. After I posted
the query about WHERE (yuk, yuk) I tried it on a restricted range and it
worked so I updated the data in place. (I have a backup.)


> ...the best practice would be to eliminate the data entry
> problem when it's entered.

Roger that. I found the data entry problem halfway through the entry
process and fixed it then. This is a one-time update to fix the entries
done before I fixed the process.

Thanks again!

-- Rick