Re: Escaping the &
From: Palani <palani_at_allpublic.ch>
Date: 2000/04/10
Message-ID: <38F195C5.14EFFC27_at_allpublic.ch>#1/1
Date: 2000/04/10
Message-ID: <38F195C5.14EFFC27_at_allpublic.ch>#1/1
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 CEST