>Can all those replies be applied in SQL Server? If not how would I approach SQL interrogation in the future so that they work in SQL Server and VFP?
Yes, the syntax will work in SQL Server too. You should remember that in SQL 2005 and prior versions SQL Server only had datetime, not date type.
If it's not broken, fix it until it is.
My Blog 
