Re: case INsensitive queries

From: Ian Cary <cary_at_gatwick.geco-prakla.slb.com>
Date: 1997/10/10
Message-ID: <343E19F8.D6EBE8FC@gatwick.geco-prakla.slb.com>#1/1

There has been quite a bit of discussion on this subject recently with the general solutions being variants on the quite correct

where upper(column) = upper(input)

I apologise to those of you who already know this, but I felt that I must point out that constructs of this type i.e. function(column) do NOT use an index and can have pretty poor performance depending on the size of table to be searched and the number of distinct column values.

Regards,

Ian Received on Fri Oct 10 1997 - 00:00:00 CDT