Rene:

I've done a lot of work with SQL Server over the last few years, and while it has a lot of nice features, I still think VFP has a lot to offer. Here are a few areas where VFP may have an advantage over SQL Server.

(1) No licencing issues with VFP.

(2) VFP can be setup thin client. A VFP application running on the server (COM object or Web Service) executes your queries in their own memory space just like a SQL database. Use XML to communicate with server side components.

(3) The VFP cursor engine is FAR superior to SQL Server. Trying working iteratively with a SQL Cursor. Its a joke!

(4) The VFP language is way more flexible than T-SQL.

(5) SQL Server can not act as a file server database.

(6) No DBA needed with VFP.

The main advantage of using SQL Server over VFP is security and data integrity. However, there are ways to get around it.

Hope this helps,
Charlie