Hi,

>The "%" sign may be at the beginning, or at the end; therefore, Visual FoxPro can't optimize the query with an index. That is, an index on field REFN can't be used.
>

In my case, the % is always at the end.