Re: oracle forms 5.0 queries!

Hi Janaka.

The easiest way to do it is to convert the result of your select, and the data entered into upper case using the UPPER() string function..

SELECT UPPER(FIELD1), UPPER(FIELD2) FROM MYTABLE WHERE UPPER(FIELD3) = UPPER(USER_INPUT); Same can be applied to the WHERE property...

UPPER(Scott Morrow) <Grin>
razors_edge_at_nospam.geocities.com

*Please remove the 'nospam' to e-mail me*

janakah_at_my-dejanews.com wrote:

> 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 Mon Dec 21 1998 - 17:52:56 CST