Re: quotes problem

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Tue, 24 Aug 1999 17:29:31 +0200
Message-ID: <7pudq3$bgi$1@oceanite.cybercable.fr>

Are you sure that the second doesn't work? See:

SQL>create table store (name varchar2(100));

Table created.

SQL>insert into store values ('John''s Used Cars');

1 row created.

SQL>select * from store;

NAME

---

John's Used Cars

1 row selected.

SQL>select * from store where name ='John''s Used Cars';

NAME

---

John's Used Cars

1 row selected.

siddsoni_at_hotmail.com a écrit dans le message <7puasj$198$1_at_nnrp1.deja.com>...
>I want to execute this SQL:
>select * from store where name = 'John's Used Cars'
>
>I also tried:
>select * from store where name = 'John''s Used Cars'
>
>Neither works. What am I supposed to do?
>Thanks.
>
>
>
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Tue Aug 24 1999 - 10:29:31 CDT