Re: apostophy porblem in SQL*PLUS

From: Gary Assa <gsa_at_li.net>
Date: 1996/11/04
Message-ID: <55ktie$3l3_at_linet01.li.net>#1/1


>update atable
> set
> charfield1 = '&TEXT1',
> charfield2 = '&TEXT2'
> where conditions are met.
>

put a double apostrophe when entering the data as such:  

Pete''s Wicked Ale

-- 
=========================================================
            http://www.li.net/~gsa/index.html
This is my signature file, not part of this mail message.
Received on Mon Nov 04 1996 - 00:00:00 CET

Original text of this message