>Hi:
>
>We are currently developing a n-tier client server application that will communicate with FoxPro 2.6 tables to begin with. Later in the design cycle, we plan on upsizing to SQL Server.
>
>I'm currently using SPT for retrieving data from FoxPro 2.6 tables. So my question is, are there any SQL grammer differences between SQL Sever and FoxPro such that my SPT queries may fail if I swap database backends?
>
>I'm wondering what commands are not supported, such as: DTOC(), STR(), etc... that my SPT queries will fail upon upsizing to SQL Server. Is there documentation that identifies these differences?
>
>Thanks!

Basically, don't use VFP functions or commands in the SQL statement, don't use double quotes, and don't use "where myfield IS NULL" in your filters.

If your wondering what commands are not supported, you should probably buy a SQLServer book and look it up. Otherwise, use ansi92 standard SQL and do datatype conversions after you hit the backend.

IOW, treat your Fox tables the same as if they were some unknown ODBC compliant data source.