Re: Escaping the &

Michael C. Wilkerson wrote:
>
> Is there any way to escape an & in a string?
>
> If I attempt to insert 'Sound & Music', Oracle always prompts me for the
> value of Music
> because it thinks I'm specifying a variable.
>
> It will work if I break the string up into 'Sound ' || chr(38) || '
> Music' but I was hoping someone could give me
> an easier way.
>
> Thanks,
> Michael

SQL> set define off

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse