>>FWIW, I never start a column name with a letter indicating its data type. That prevents confusion when using variables. DESCRIPT is a column name while cDESCRIPT or lcDESCRIPT is a variable.
>
>I completely and strongly disagree with this. I always name columns starting with first letter as their type... then there is no need to worry about running into a reserved word, and you have LESS confusion because you have some idea of what the field type is.
>
>I would also never name a variable in a program cDescript - instead, I always use something like lcDescript.
cDescript, for example, is usually the convention used for the parameter name in a parameterized view. I think you will find most here disagree with your naming approach for fields. AFAIC, naming a field nNumber, for example, is just as bad as naming it Number.
Mark McCasland
Midlothian, TX USA