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

1. The ascii code for & is 38 (not 39)
2. Which Oracle version are you using ?
3. What tools are you using to send the string to Oracle ?
4. In some things (like html), & is used as a lead in character for special characters. Å would produce an Amstron unit - an 'A' with a ring over it.

John David Birch

<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'.
> I only have a few sql books and I can't find the proper syntax to use
> so it will include the "&" within the character string. Just like there
> is a proper syntax for including an apostrophe within the quotes of a
> string, i.e. 'O''Brian', I know there has to be a way to do this, but I
> can't stay up any longer trying to figure it out. Somebody please help
> me.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Nov 01 1999 - 03:34:49 CST