Nelson:

I don't think VFP drags the entire table down the wire to run a query. It's mostly index data. Does anyone want to comment on this?

Also, having a VFP application running on server (COM app) will allow queries to run in a seperate process like SQL Server. This is a very cost effective option for VFP apps running on WAN. Also, you have the benefit of VFP for data access, which IMO, is more flexible that T-SQL.

Charlie