Re: Newbie Cursor Question

"Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote in message news:1118058278.372169.232510_at_g44g2000cwa.googlegroups.com...
>
> Why not just use,
>
> update oms_version_tbl
> set ver_drg_title = replace(ver_drg_title, chr(38), 'AND')
> where instr(ver_drg_title, chr(38), 1, 1) > 0;
>

Many thanks Rauf, that's what makes me a clueless newbie and you an expert. :o) Received on Mon Jun 06 2005 - 07:33:53 CDT