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!