Re: How to stuff ' in varchar2 variable

From: Lee Levy <levy.lee.ls_at_bhp.com.au>
Date: 1996/03/01
Message-ID: <4h5kkk$725_at_gossamer.itmel.bhp.com.au>#1/1

In article <4gvtje$13q_at_hubcap.clemson.edu>, raj_at_cs.clemson.edu (Raj Rangarjan) says:
>
>Hi,
> does anyone know how to stuff a ' character into a varchar2
>variable. I need to get a string intialized to something like
>this(joe's)
>
>my_varchar2_variable:='Joe's'
>
>but I can't get the ' in there- used to know how to do it but can't
>remember- any help would be appreciated. Please post your replies here
>or send them to raj_at_cs.clemson.edu

I've always used
>my_varchar2_variable:='Joe''s'

ie. a two single quotes, and it has always worked fine

HIH
Lee

------/\/\------+---------------------------------------------------
     / / /\     |  Lee Levy, ISSD Systems Development, Del Code (34)
    / / /  \    |  BHP Information Technology,  ACN 006 476 213
   / / / /\ \   |  PO Box 261, Warrawong, NSW 2502, Australia

   \ \/ / / / | PH: +61 42 75-5485 Fax: -5500 Tie: 8855-     \ / / / | Internet : levy.lee.ls_at_bhp.com.au

-----\/\/\/-----+---------------------------------------------------

Opinions expressed are mostly my own, so give me some credit. Received on Fri Mar 01 1996 - 00:00:00 CET