Re: How to insert strings with apostrophes?

From: Nitin Dahiya <ndahiya_at_hotmail.com>
Date: Fri, 23 Jul 1999 20:49:06 +0200
Message-ID: <7nc71a$abj$6@pumba.class.udg.mx>

do this instead
INSERT INTO tablename VALUES ('This'''ll not fail for sure')

                                                                ^^^^

regards,
nitin.

Christopher Allen <progplusSPAMBEGONE_at_gte.net> wrote in message news:Cosl3.763$HF.24088_at_dfiatx1-snr1.gtei.net...
> OK, this must be in No-Brainer 101, but I've forgotten how to construct an
> INSERT statement where one of the string values being inserted includes an
> apostrophe. For instance,
> INSERT INTO tablename VALUES ('This'll fail for sure')
>
> ...will fail, because the apostrophe in "this'll" is intrepreted as is
> intrepreted as the end of the string.
>
> Suggestions are welcome!
>
> Thanks,
> Christopher
>
>
Received on Fri Jul 23 1999 - 13:49:06 CDT