>>>SeatsRow? :-)
>>Hi,
>>cRow or nRow or iRow depending on its type
>>
>>would do
>>
>>Koen
>
>It is not a good idea in SQL Server to add field type as part of a column's name.
SQL server doesn't care. You can actually use any keyword as a field name, even names with spaces (seen this in converted Access apps), as long as you write them in brackets.
OTOH, I've found the practice of prefixing field names with xxx_ (where xxx is the same for all fields in one table, and unique to that table) very useful foxside, so the field names are never confused with variables. And then there was one metadata table where this rule wasn't respected, and it took half an hour to track one nasty bug caused by an overlap of a variable and a field name.