Gerald,

Hope you don't mind me jumping in - there are several differences between SQL Server SQL and VFP's version of SQL. I'm not aware of a full list, but you might try to do a search over on the Fox forum.

Here are the ones that immediately come to mind between VFP8 and SQL Server that I've encountered:

1) For conditional in-line statements, VFP has the IIF() function, whereas SQL Server allows a CASE structure

2) There are different types of sub-queries that will run in SQL Server that won't run in VFP (though VFP9 will bridge that gap and make it closer to the SQL-92 standard)

3) Part of #2...SQL Server supports scalar subqueries to query and summarize data against multiple 1-many relationships. In VFP you'd need to include a UDF to do this.

4) SQL Server has T-SQL (Transact SQL) for writing stored procs, UDFs, triggers, etc., and the syntax is different from Fox - though that may be outside the scope of anything you need to account for.

Then again, maybe not always. For example, if I want to get the most recently assigned identity column from SQL Server, I can do a SELECT Scope_Identity()....I don't know off the top of my head what the equivalent is for VFP. Another example is CREATE TABLE, which has some differences on both sides.

I'm sure there are others...

Part of it may depend on your query requirements - as I look back to some VFP and SQL Server code I've written to do SQL, some could have been ported from one to the other with little or no changes, whereas others would have needed pretty involved changes.

Kevin