>Not a peculiar question at all. In fact, VFP selects all the records then dumps all but the top 99. So it's not a very efficient method, it's just a bit more convenient than having to pull out the top 99 yourself.
>
>>Hi All!
>>
>>I have a peculiar question regarding TOP clause in SQL Select.
>>How does VFP perform this task: (let's say I want the top 99 records)
>>1. VFP fetches all appropiate records, orders them and deletes unwanted ones on the end above 99, or
>>2. VFP uses the index of ordered field in base table, and fetches only the records that fall under 99 according to the index.
>>
>>TIA
>>
>>BB

Thanks Josh!

That's what I was afraid of!!!

BB