From: "John Alexander" <jalexander@summitsoftwaredesign.com>
Newsgroups: comp.databases.oracle.tools
References: <95d19m$kev$1@news3.cadvision.com>
Subject: Re: Inserting a value with an apostrophe?
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <xcne6.75840$8V6.9643415@typhoon.tampabay.rr.com>
Date: Fri, 02 Feb 2001 00:30:21 GMT
NNTP-Posting-Host: 24.92.196.125
X-Complaints-To: abuse@rr.com
X-Trace: typhoon.tampabay.rr.com 981073821 24.92.196.125 (Thu, 01 Feb 2001 19:30:21 EST)
NNTP-Posting-Date: Thu, 01 Feb 2001 19:30:21 EST
Organization: RoadRunner - TampaBay


Use a double apostrophe:
INSERT INTO EMP (EmpName) VALUES ('Jeff''s Name');

John Alexander
www.SummitSoftwareDesign.com
St. Petersburg, FL

Jeff Boyer <jdboyer@(remove)icomproductions.ca> wrote in message
news:95d19m$kev$1@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
>
>
>