Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Escaping the &

Escaping the &

From: Michael C. Wilkerson <Mike.Wilkerson_at_uscreative.com>
Date: 2000/04/07
Message-ID: <38EE0041.A50C321F@uscreative.com>#1/1 






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 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US