Re: newbie insert question using replace function

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