>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.
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown