On Thu, Jul 12, 2012 at 9:33 AM, peixinhosdalua <peixinhosdalua@...>wrote:

>
> In this case, the goal is to make '%word%' not 'word%'. In understand your
> suggestion but it is not what i need to achieve.
>

Firebird cannot use an index on partial word matches unless it knows the
initial characters, so your queries are all going to require full table
scans.

Good luck,


Ann


[Non-text portions of this message have been removed]