That works, thanks. I should have used single quotes.
"Roman Mirzaitov" <rmirzaitov_at_kt.kg> wrote in message news:<a90d46$vtp3b$1_at_ID-127142.news.dfncis.de>...
> Hi,
>
> try the following:
> update <table>
> set field1 = replace(field1,'&','and')
> where field1 like '%&%';
>
> Regards,
>
> --
> Roman Mirzaitov
> Brainbench MVP for Oracle Administration
> www.brainbench.com
>
> "Paul Fell" <novaweb_at_iinet.net.au> wrote in message
> news:4b270a4e.0204091911.6c80b291_at_posting.google.com...
> > I'm trying to use the replace function in plsql. I'm new to Oracle.
> > Here's what I want to do :
> >
> > update <table>
> > set field1 = replace(field1,"&","and")
> > where field1 = "&"l
> >
> > I get a compilation error. Should I be using a cursor and feeding the
> > variable inot the replace function?
> >
> > tia
> > Paul
Received on Wed Apr 10 2002 - 21:50:12 CDT
