It's incorrect assumption. With proper indexes FoxPro will find record(s) location using an index and than only return those records that satisfy a query conditions.
>Well, my understanding is that if you are using VFP tables the clinet computer has to process de SQL command that you send, that is all 2000000 need to travel across the network to be evaluated at the client computer in order to give you a result set even if that set is only one record.
>
>If you want only one record to travel across the Net you need client-server. That way when you sen a SQL command the server will process it and return only one record.
>
>I suggest that you move the table to a SQL or MSDE and let the server do the selecting for VFP.
>
--sb--