>>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.
Or if it's not a real field name, like I've seen in some cases where an Access mdbf was ported by a warlock, wizard or some such medieval expert, and the column names contained spaces, parentheses, question marks and other murky characters.