>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.
According to what Naomi says in another message, in this case VFP 9 is intelligent enough to optimize. (I didn't know that.)
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)