>>I also have Join, Order By, and Group By clauses in some of the Select statements that I need to get cleaned up as well.
>>
>>I'm trying to avoid adding brackets manually, because for a while the SQL statements still need to run against DBFs tables, so I if add them now, it will break the DBF version of the app. I know there are other VFP vs. Sql Server issues that I must address, but this is the biggest one I am facing now.
>>
>
>Why do you need brackets around the fields when working with SQL Server? I think you only need the brackets if the field name is a reserved word in SQL Server.
Only if it's a reserved word or has characters that should not generally be in identifiers such as spaces.
If it's not broken, fix it until it is.
My Blog