Problem : Doing case-insensitive queries...

Hi all,

I have to select several lines out of a very large Table. The SQL-Statement goes like this:

select name from MyTab where name = 'bill'; (simplified)

For more comfort we have an index on column name.

The Problem is that I need to select those lines _case-insensitive_. That meens I need to select lines with 'bill','Bill' and some stupid users insert 'bIlL'.

Therefore my select-statement was changed to:

select name from MyTab where upper(name) = 'BILL'; (still simplified)

This statement lasts about 4 times longer than the first one. Is there a way to avoid using UPPER but still to select case-insensitive ?

Please answer via EMail to BKeirinn_at_lp-software.de.

Thanks in advance.

--
------------------------------------------------------
Thorsten Redicker

EMail:  thorsten_at_ankh.ping.de (private only)
        TRedicker_at_LP-Software.com

Lenz und Partner GmbH
Königswall 21 (Harenberg City-Center)
D-44137 Dortmund