Re: Escaping the &

From: Stéphane Martel <martste_at_cognicase.ca>
Date: Fri, 7 Apr 2000 12:15:34 -0400
Message-ID: <9OnH4.4527$HG1.128422@nnrp1.uunet.ca>

you can also use 'Sound'||' & '||'Music'

Stéphane Martel
(418) 877-4615 poste 22
Cognicase Technologie Internet
Une division de Cognicase inc.
site : http://www.cognicase.ca
courriel : mailto:stephane.martel_at_cognicase.ca

"Michael C. Wilkerson" <Mike.Wilkerson_at_uscreative.com> a écrit dans le message news: 38EE0041.A50C321F_at_uscreative.com...
> 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 Fri Apr 07 2000 - 11:15:34 CDT