Re: How to insert strings with apostrophes?

From: K Raza <ELN/Kraza_at_earthlink.net>
Date: Wed, 21 Jul 1999 16:20:16 -0700
Message-ID: <7n5kcq$jv4$1@holly.prod.itd.earthlink.net>

Try INSERT INTO tablename VALUES ('This''ll not fail for sure')

There are two single quote marks after This.

Christopher Allen wrote in message ...
>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 Wed Jul 21 1999 - 18:20:16 CDT