Re: inserting quote into column

From: R. Wayne Linton <linton_wayne/SCAN6_at_shell.ca>
Date: 1997/06/13
Message-ID: <33A17DF7.6B5B@shell.ca>#1/1

double up your quote - for example ....

... MASTER''S DEGREE ...

-- 
R. Wayne Linton, I.S.P.
Database & Systems Management
Shell Canada Ltd.


Ron Heeb wrote:


> 

> the following insert gives me an error because i am trying to include a

> single quote within the string:

> 

> insert into xxx values ('13','A','28',

> '        COMPLETE THE YELLOW APPLICATION FOR MASTER'S DEGREE AND DIPLOMA','ADREC

> ');

> 

> is there a way to insert a single quote?

Received on Fri Jun 13 1997 - 00:00:00 CDT