>I'm currently using VFP database, but would like to convert to SQL server soon. I do a lot of coding using the VFP SQL statements. Will I need to change these VFP SQL statements to be useable for SQL server database? How should I code database access now in VFP using VFP databases so that when I am ready to convert, not much code change is needed?
>
>Here is a sample of my VFP select statement as I have it now (with VFP table):
>SELECT * FROM table1 WHERE field1='DONE'
>
>How would this be changed to work with SQL server table?
>Thank you all!

That same SELECT would work with SQL Server. Of course depending on the statement it might or might not work.

See thread #532360 for more pointers. HTH