Subject Re: [firebird-support] SELECT UPPER(MY_FIELD) -> DON'T USE INDEX
Author Thomas Woinke
Hi Sergio,

On Tue, Apr 22, 2008 at 5:20 PM, Sergio H. Gonzalez
<shg_sistemas@...> wrote:
> Hi Martijn! Thanks for the answer!
>
> So with FB1.5 it's imposible to use an index for that? It's ok to do the
> query anyway? How did you do it with 1.5?

you could use shadow columns filled by triggers and then search the
shadow column as described here:
http://www.destructor.de/firebird/caseinsensitivesearch.htm


/thomas