Re: inserting single qutoes in string???
From: Balakrishna Avula <100610.52_at_compuserve.com>
Date: 1996/03/27
Message-ID: <4jbmu4$5ua_at_relay2.uk.mdis.com>#1/1
Date: 1996/03/27
Message-ID: <4jbmu4$5ua_at_relay2.uk.mdis.com>#1/1
Atomic.software_at_pobox.com (Allan Marcus) wrote:
>is there a way (from sql*plus) to insert a single quote in a varchar field?
>This is, of course, a problem since the single quote usually delimits a string.
>Thanks,
>Allan Marcus
>"My opinions are my own, I think..."
>AppleLink: Allan.Marcus
>CIS: go ATOMIC, section 7
>InterNet: Atomic.Software_at_pobox.com
>eWorld or NewtonMail: Allan.M
>AOL: Atomic.Software_at_pobox.com
>Day Job email: allan_marcus_at_lanl.gov
>Day Job Voice: 505-665-1828
>Home Voice: 505-672-0370
>-------------------------------------------------
Try some thing like
insert ...
values ('Smith''s birthday')
ie. to use two single quote to insert a quote.
-- Balakrishna Avula 28 Ashby Court Alpha-Tek Associates Ltd. Hemel Hempstead Technical Consultant HERTS HP2 7QL 100610,52 on Compuserve UK http://ourworld.compuserve.com/homepages/BAvula/homepage.htm on WWWReceived on Wed Mar 27 1996 - 00:00:00 CET