This may be the case, what I found that there was a perceivable speed difference with both ON rather than both OFF.
>>No, you do your own testing. It is not the SET EXACT but the SET ANSI that effects the SQL Selects, the SET EXACT is a logical preference, as if I do a SEEK I want an exact match not a generic match, if I want a generic I will SET EXACT OFF and set it back on after I am finished.
>
>I don't know if it's still true, but at one time, VFP was faster if SET EXACT and SET ANSI were set the same.
>
>Tamar
Regards N Mc Donald