Hector,

And vice versa. For example you can do things like ;

INSERT INTO xTable
(SELECT a.* FROM yTable a WHERE a.Somefield IN (SELECT b.Somefield from zTable b))

Wish we had this in VFP.

Cheers


>Not wisdom by any means, just a couple of things to watch for :)
>
>* SQL Server does not support empty dates. In SQL Server they are either 1/1/1900 or NULL. This has great impact on queries where you want to filter by date.
>
>* SQL Server is by default case insesitive. As far as I remember you define how SQL Server will behave when you install it and you cannot change it. I like it case insesitive.
>
>* I am sure you know, but just in case, you must remember not to use VFP functions inside SQL commands that will be processed by SQL Server. You can use SQL Server own set of functions, though.
>
>* SQL commands in SQL Server can be as long as the universe. I love this, you are not limited on how long your statements can be.
>
>* SQL Server is a little bit more strict on SQL statements syntax. There are a few things that you can do in VFP that you cannnot in SQL Server (specially when it comes to GROUP BY and HAVING)
>