>Long enough for SQL Server to say 'Executing Query Batch', increment the time, then say 'Query Batch Complete'. The same query run in Fox kicked backed the results instantaneously. Even though VFP didn't register the time, it was clearly faster.
>
Charlie,
I misread your results, I read it as .04 seconsd when it was 4 seconds. I think it was Christof that said you need to add the NOFILTER option on the VFP SELECT to see a fair comparison.