Re: Inserting a value with an apostrophe?

That worked great, but now how do I do this when the user is inputting the value themselves? This will only happen in some cases but I would like to be able to acept them when they do.

Thanks,
Jeff
"John Alexander" <jalexander_at_summitsoftwaredesign.com> wrote in message news:xcne6.75840$8V6.9643415_at_typhoon.tampabay.rr.com...
> Use a double apostrophe:
> 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 Wed Feb 07 2001 - 19:47:35 CET