>If EXACT IS OFF, and I run an optimized query with just the first few letters of the field I am querying on, will that slow down Rushmore?
>
>Thanks
>Kev
Kevin,
First, SET EXACT doesn't affect SELECT - SQL at all. SET ANSI controlls 'how comparisons between strings of different lengths are made with the = operator in Visual FoxPro SQL commands'.
Second, IF SET ANSI is off than your query still be fully optimazable.
--sb--