Re: Dont Quote Me

From: Jingkai Yu <jkyu_at_cs.wayne.edu>
Date: Wed, 5 Sep 2001 12:36:53 -0400
Message-ID: <9n5kb3$1nc$1@cwis-1.wayne.edu>

Try
INSERT INTO TABLE (ADDRESSFIELD) VALUES ('20 Dunaway''s Lane, London');

Using double single quote (two single quotes together) shall give a single quote in the table.

HTH Jingkai

"Raymond Sebuwufu" <sleepinglion40_at_hotmail.com> wrote in message news:999526219.455620_at_ernani.logica.co.uk...
> Dear all I am trying to insert data into a
> varchar(255) field. Normally this would not be a problem but the data has
> single quotes in it which confuses the SQL interpreter.
>
> Ex. INSERT INTO TABLE (ADDRESSFIELD) VALUES ('20 Dunaway's Lane, London');
>
> The apostophe is interpreted by SQL as terminating the string.
>
> I have tried both escape sequences "\" and "{}" however they just seem to
> add themselves to the final data which I do not want. I want the data in
the
> database as it is present without the escape sequences.
>
> Please reply as soon as you can if you know the answer to this most
> frustrating problem.
>
> Regards
>
> Raymond
>
>
Received on Wed Sep 05 2001 - 11:36:53 CDT