>Hi Craig,
>
>Thanks! You might want to download article Q191172 from MS. It relates to that problem and suggest that we use HAVING instead of WHERE in our SQL statements.
>
>The article doesn't necessarily relate to my problem. My test SQL was "Select Distinct from Xtable". No where clause. The test ran significantly FASTER on a 233mhz Win 98 wkst with 64m of ram (VFP 5.0) than on a 4.5mhz II NT 4.0 WkSt with a 128m of ram using VFP 6.0. Also as I stated originally it ran even faster on a 233mhz NT 4.0 Server with 128m using VFP 6.0 than it did on the Win 98. But that is understandable -more ram and a SCSI drive. If I chase it down, I'll get back to you.
>
>Regards,
>
>Paige
HAVING is used to filter the result set rather than filtering the source tables.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer