We have a need for a case insensitive search on all words within a field.

If we use containing we get the results we need, however we lose index
benefits. Likewise if we use "like '%value%'" we cant use an index.

Is there a "simple" way of meeting our needs?

Thanks in advance..

Ian