Re: reset escape character
From: Gary M. Lewis <cc000765_at_interramp.com>
Date: 1996/01/01
Message-ID: <4c8tnb$72t_at_usenet4.interramp.com>#1/1
Date: 1996/01/01
Message-ID: <4c8tnb$72t_at_usenet4.interramp.com>#1/1
In article <1995Dec29.163222.12707_at_nosc.mil>, binh_at_cod.nosc.mil says...
>
>Hi Folks,
>
>I would like to be able to insert/update
>some tables with values such as "o'clock" and "ol'boy".
>Currently, it takes the aphostaphe, which is part of
>the string I want to insert, as the closing/ending quote
>for the strings.
>
>Binh Tran
>binh_at_nosc.mil
Binh - All you'll need to use is two single quotes in the string, as in: insert into TABLENAME values ('o''clock');
Gary Received on Mon Jan 01 1996 - 00:00:00 CET