Re: Inserting a value with an apostrophe?
From: John Alexander <jalexander_at_summitsoftwaredesign.com>
Date: Fri, 02 Feb 2001 00:30:21 GMT
Message-ID: <xcne6.75840$8V6.9643415_at_typhoon.tampabay.rr.com>
Date: Fri, 02 Feb 2001 00:30:21 GMT
Message-ID: <xcne6.75840$8V6.9643415_at_typhoon.tampabay.rr.com>
Use a double apostrophe:
[Quoted] INSERT INTO EMP (EmpName) VALUES ('Jeff''s Name');
John Alexander
www.SummitSoftwareDesign.com
St. Petersburg, FL
Jeff Boyer <jdboyer_at_(remove)icomproductions.ca> wrote in message
news:95d19m$kev$1_at_news3.cadvision.com...
> Can anyone tell me how to get around the error that occurs when an value
> being inserted into a field has an apostrophe in it. The SQL insert
> statement thinks the apostrophe is the end of the statement and crashes.
>
> Ex. INSERT INTO EMP (EmpName) VALUES ('Jeff's Name');
>
> It doesn't like the apostrophe in "Jeff's"
>
> Thanks
>
> Jeff
>
>
>
Received on Fri Feb 02 2001 - 01:30:21 CET