Hi Matt,
1) You should try running your application with EngineBehavior 90, since that's closer to what SQL servers use.
2) SQL servers are much more sensitive to the order of clauses in the SQL statement. Where in VFP you can put ORDER BY before WHERE the same is not possible for most servers.
3) If your SQL statement refer to fields from tables that are not part of the query or variables, you need to convert them to parameters.
--
Christof