Re: inserting quote into column

Ron,

Use the chr() function. The single quote is chr(39), so it would be Master' || chr(39) || 's', or something like that.

Hope this helps,

Tom Mettling
W.T. Chen & Company, Inc.
mettlingt_at_wtchen.com

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? since i'm going on vacation
> it
> might be best to send an email as well as posting the response. thanks
> in
> advance, ron
>
> --
> Ron Heeb, Webmaster
> Mgr., Applications Development, ITR
> California State University, Northridge
> email: ron.heeb_at_csun.edu, webmaster_at_csun.edu
Received on Fri Jun 13 1997 - 00:00:00 CDT