From: "Jeff Boyer" <jdboyer@(remove)icomproductions.ca>
Newsgroups: comp.databases.oracle.tools
Subject: Inserting a value with an apostrophe?
Date: Thu, 1 Feb 2001 17:02:34 -0700
Organization: CADVision/PSINet
Lines: 13
Message-ID: <95d19m$kev$1@news3.cadvision.com>
NNTP-Posting-Host: 207.228.84.134
X-Trace: news3.cadvision.com 981076086 20959 207.228.84.134 (2 Feb 2001 01:08:06 GMT)
X-Complaints-To: news@cadvision.com
NNTP-Posting-Date: Fri, 2 Feb 2001 01:08:06 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400


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