How to stuff ' in varchar2 variable

From: Raj Rangarjan <raj_at_cs.clemson.edu>
Date: 1996/02/27
Message-ID: <4gvtje$13q_at_hubcap.clemson.edu>#1/1

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

Thanks

--

---

-Rajasekaran Rangarajan
-Administrative Progamming Services
-Clemson University
-Ph:(864) 656 0731/ Fax:(864) 656-0122
Received on Tue Feb 27 1996 - 00:00:00 CET