Re: Help - SQL update of character field in table

From: Alex Schroeder <asc_at_bsiag.com>
Date: 1998/10/26
Message-ID: <uk91nk6j4.fsf@bsiag.com>#1/1

>>>>> "Steve" == Steve Agnew <agnews_at_inforamp.net> writes:

    Steve> I'm new to SQL Plus, so I hope this question isn't to
    Steve> stupid...  I would like to know how to update a character
    Steve> field in a table when the information being added contains
    Steve> a single-quote.

Steve> Is there some way to get around this problem?

Sure, use two quotes: set town = 'Miller''s Creek';

Alex.

-- 
WWW:	<URL:http://www.geocities.com/TimesSquare/6120/>
mail:	<URL:mailto:a.schroeder_at_bsiag.ch>

Received on Mon Oct 26 1998 - 00:00:00 CST