>>>Did you post exact query or actual one is different?
>>
>>Yes " post exact query ".
>
>Fire SQl Server Profiler to see what VFP sends to SQL Server and how it's processed.
SQL Server Express doesn't have Profiler installed.
If it's not broken, fix it until it is.
My Blog