Della,
In addition to what others have said, I'd like to add that one big difference when it comes to VFP/SQL Server conversion tasks is related to GROUP BY sentences. On SQL Sever, when you use a GROUP BY clause, the fields listed in the SELECT portion must be in an aggregate function or be listed in the grouped fields on the GROUP BY.