Re: quotes problem

From: Prakash V <venkatprakash_at_hotmail.com>
Date: Wed, 25 Aug 1999 17:31:42 GMT
Message-ID: <19990825173142.42126.qmail@hotmail.com>

SQL> create table temp (x varchar(20));

Table created.

SQL> insert into temp values ('Test''s data');

1 row created.

SQL> select * from temp;

X

---

Test's data

SQL> select * from temp where x like 'Test''s%';

X

---

Test's data

Thanks

V Prakash

---

Get Your Private, Free Email at http://www.hotmail.com

 Sent via Deja.com http://www.deja.com/  Share what you know. Learn what you don't. Received on Wed Aug 25 1999 - 12:31:42 CDT