Re: Escaping the &

select 'Sound '||'&'||' Music' from dual;

Thanks
Palani

"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
  Received on Mon Apr 10 2000 - 00:00:00 CDT