Re: Question on Case-insensitive queries

In article <1993Jul12.111550.22878_at_amoco.com> you write:
>In article HIA_at_isst.fhg.de, umatz_at_isst.fhg.de (Udo Matzinger) writes:
>>Sudhakar Bhagavatula (sab3_at_Ra.MsState.Edu) wrote:
>>: Hi,
>>: Could someone please tell the method to perform Case-insensitive
>>: queries. Please send me an e-mail to:
>>: sudhakar_at_cs.msstate.edu
>>:
>
>to do this all you need is UPPER(field_name) LIKE '%ADBGGFF%'
>

Best way I know of is to use insert and update triggers to store an uppercase version of the data. Index this, and then you can do indexed queries against it. The problem with using UPPER() in a select statement is that it turns off the index on that column. So you speed retrieval time at the expense of storage.

• Dan

Daniel Druker
Anderson Graduate School of Management at UCLA                    

| Dan Druker                                                               |
| agsm mail 	: ddruker                                                  |
| internet 	: ddruker_at_agsm.ucla.edu                                    |
| oracle*mail	: unix:ddruker_at_agsm.ucla.edu                               |
----------------------------------------------------------------------------

Disclaimer: None. I'm a student now and I don't care what you think. Received on Tue Jul 13 1993 - 01:30:48 CEST