The part of the index on ncust_id that would allow FoxPro to find location of the record with ncust_id = 3 would be transferred over the wire.
>
>Let me put it this way, if I do sql passthru let's say from foxpro to SQL Server as example "select * from customer where ncust_id = 3" then only one record goes over the wire,but if the database is foxpro and there's 1 index on ncust_id and I have the same query, what would be transferred over the wire apart from the one record?
--sb--