Ian wrote:

>That solves the case insensitivity! but what about the
>"myfield like '%value%'" and "containing 'value'" not using the index?
>
>This is my bigger problem, since i am in a position to FORCE uppercase
>input at the moment

Take a look at http://www.ibobjects.com/ibofts.html - the full text search
module is a pretty new extention to IBO (I haven't tried it myself).

and Woody wrote:

>I hope there are plans for future IB versions to have a case-sensitive

flag >for the like command. Either that or make the containing keyword more
flexible

>so that you can specify substr position using wild cards.

Don't know how feasible it is, but I think I would prefer it to be possible
to create case insensitive indexes.

Set