--- In ib-support@y..., hans@h... wrote:

> A partial solution
>
> WHERE UPPER(NAME) LIKE 'WOOD%'
>
> I don't know if this uses an index or not and if it
> degrades speed significantly, since UPPER is not a UDF.

From IB OpGuide.pdf:
...
What queries don't use indexes?
InterBase doesn't employ an index in the following operations, even
if an index exists for the specified columns:

Search criteria for CONTAINING, LIKE, and <> inequality operations

Columns used in aggregate functions, like COUNT()

Other expressions, like UPPER()
...
I think LIKE 'XY%' use indexes, but LIKE '%XY%' doesn't.

Regards
Richard