index to speed up UPPER(column) ??

Hello everybody !

In some of our queries it's import to find data wether it is uppercase or lowercase. If I define an index on the column with the chars I don't get any speedup if I do
SELECT abc from yxz
WHERE UPPER(charcolumn)=:myparam
(myparam comes from a delphi program)

Is there a way to define some kind of index, that will speedup the query ? Or do I have another possibility to get a fast selection that doesn't make differences between uppercase, lowercase and mixtures of them (I think in SQL-Server it is an installation option)?

Ciao and Thanks, Michael.

--
Michael Keppler, MCSE
IT logic GbR
Michael.Keppler_at_gmx.de Received on Thu Sep 02 1999 - 12:18:54 CDT