Re: Case Sensitivity in select

From: Prakash V <venkatprakash_at_hotmail.com>
Date: Thu, 26 Aug 1999 17:13:16 GMT
Message-ID: <19990826171316.58095.qmail@hotmail.com>

Sure. Here is the syntax for that:

SQLC[ASE] {MIX[ED]|LO[WER]|UP[PER]} And the example:

SQL> set sqlcase upper
SQL> select 'hello' from dual;

'HELL

---

HELLO 1 row selected.

SQL> select 'hEllo' from dual;

'HELL

---

HELLO Hope this will do.

Thanks

V Prakash

1 row selected.

---

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 Thu Aug 26 1999 - 12:13:16 CDT