>Hi Chris,
>
>>That is correct. from BOL:
>>
>>These reserved keywords are new to SQL Server 7.0:
>>
>>BACKUP
>>DENY
>>PERCENT
>>RESTORE
>>TOP
>
>Thanks for posting - my memory of what the problem was was a bit fuzzy.
>
>Until this problem arose for us, I didn't have an opinion on field naming conventions. The time we wasted finding the cause of this bug in our application quickly changed my mind.
>
>Best.
>
>Matt.
I am working on my first SQL Server project, version 7, and saw a post on one of the MS newsgroups concerning reserved words. Of course, I happended to have field called Date (which never caused me trouble in VFP). Glad I caught it (as well as a field called Year) before I ran into trouble.
Chris McCandless
Red Sky Software