Re: How do i Insert a ' mark?

From: Dana Stockler <stockler_at_ingdata.no>
Date: 1996/09/11
Message-ID: <323704E3.1205_at_ingdata.no>#1/1

bwskiles_at_adpc.purdue.edu wrote:
>
> Try this.
>
> insert into blah values ('John'||''''||'s Cart');
>
> > insert into blah values ('John's Cart');
 

> >
 

> > So, how to I insert the "'" mark?

Wouldn't

  INSERT INTO BLAH VALUES ( 'John''s Cart' ) ;

be more elegant?

Regards,

---

Dana Stockler

---

Home: Solstadlia 10, 1364 Hvalstad, Norway Work: IngeniørData as, Strøket 9, 1370 Asker, Norway Email: stockler_at_ingdata.no
Phone: (+47) 66 78 97 41

---

Received on Wed Sep 11 1996 - 00:00:00 CEST