I've got an upcoming project that is heavily SQL Server. I know that the SQL commands are "supposed" to be standard, but every vendor has their own extensions. Back in the eighties, I worked with Oracle and Informix, and I know enough that whatever it is I wanted to do in Oracle seemed better suited for the Informix extensions, and vice versa.

Now that I've been totally immersed in VFP's version for years, I'm wondering what I'm going to miss in VFP's syntax when I leap into SQL Server. Likewise, what am I going to find out about in SQL Server that you can't do in VFP? Do any of you have any words of wisdom on the differences between the SQL dialects?

Thanks,

- della