Paige,

You might want to read Q191172 before you waste a lot of time testing the WHERE/HAVING issue. It says:

"This bug was corrected in Visual Studio 6.0 Service Pack 3."

>Hi Cindy,
>
>As I promised here is my latest data on the subject: 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 states that actually the times INCREASE with multiple successive tests.
>
>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