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 -> Re: How do you insert "&" within a character string?

Re: How do you insert "&" within a character string?

From: Johnnie Leung <jsleung_at_telecom-digest.zzn.com>
Date: Sun, 31 Oct 1999 10:31:42 -0800
Message-ID: <iW%S3.1501$Pf3.84135@news.uswest.net> 





<rickaguayo_at_yahoo.com> wrote in message news:7vec4u$8ar$1_at_nnrp1.deja.com...


> I have tried a whol bunch of combinations for the varchar2 string


> 'D&E Supply', it doesn't want to take my ampersand within the


> string.I've tried 'D"&"E Supply','D''&''E Supply','D && E


> Supply','D'&'E Supply'.





One reliable way that I found was to use



'D' || '&' || 'E Supply'



JL



Received on Sun Oct 31 1999 - 12:31:42 CST












Original text of this message













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