Hi,

> But Firebird will *not* use an index for a prepared query like:
> SELECT ... WHERE NAME LIKE :Parm
> This is a known/documented limitation.

But you can always change this to

SELECT ... WHERE NAME STARTING :Parm

And FB will use a Index (but that's not true for CONTAINING)


Regards,
Anderson Farias