Re: Special "&" Character

From: John Alexander <jalexander_at_summitsoftwaredesign.com>
Date: 2000/06/24
Message-ID: <p3U45.10719$h4.58510@typhoon.tampabay.rr.com>#1/1

Separate the ampersand from the rest of the string:

insert into temp_table values ('HHH'||'&'||'PPP');

John Alexander
Summit Software Design

Ethan Post <epost1_at_my-deja.com> wrote in message news:8j0m07$m9e$1_at_nnrp1.deja.com...
> insert into test values('This &q');
>
> When I insert this value the @q is prompting me for a value as opposed
> to actually inserting the value "&q". What do I need to do to get it
> to insert "&q"?
>
> -Ethan
> http://www.gnumetrics.com
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Jun 24 2000 - 00:00:00 CDT