oracle forms 5.0 queries!

Hi,

Stated below is my problem. I got a database table with a varchar2 field. Data enterd in this field is smoetimes in uppercase and sometimes in lower case. So when the users tries to fetch data through forms 5.0, if they enter the search criteria in lower case and the data is in upper case they cannot retrieve it. I don't want to set the "case restriction" property as the user wants the option of entering data either in uppercase or lowercase. Is there a way of converting data to either uppercase or lowercase at query time.

TIA Janaka

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sun Dec 20 1998 - 20:52:23 CST