Case sensitivity in Oracle

HI...
Have a question on controlling case sensitivity in Oracle... Is it possible to get rid of case sensitivity so that :

   select A from TableA where A = "PEOPLE"; would return rows PEOPLE, People, people, PeOpLe, etc. as opposed to just PEOPLE? This is imperative for a certain project because of the use of a query tool which you can't automatically use the UPPER() function, etc. in, when user data is entered so that entering PO instead of po, for example, becomes an issue.

Thanks for any help,
Noah Wollowick
nwollowi_at_allegro.cs.tufts.edu Received on Wed Nov 27 1996 - 00:00:00 CET