>>>>>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.
>
>A couple of options:
>http://www.mssqltips.com/tip.asp?tip=1035
>http://sqlprofiler.googlepages.com/ recommended by: http://blogs.microsoft.co.il/blogs/adlaim/archive/2009/04/13/sqlserver-express-2008-profiler.aspx

Right, thanks - I think I even posted a link to this free tool myself, but haven't loaded it. I will do so very soon.

Thanks again.