Re: inserting quote into column
From: R. Wayne Linton <linton_wayne/SCAN6_at_shell.ca>
Date: 1997/06/13
Message-ID: <33A17DF7.6B5B_at_shell.ca>#1/1
Date: 1997/06/13
Message-ID: <33A17DF7.6B5B_at_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:Received on Fri Jun 13 1997 - 00:00:00 CEST
>
> 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?