When deciding if a field must be numeric or character, I ask myself this question: Is this field will be used in a calculation? If the response is no, it will be a character field, otherwise, it will be numeric.

>Changing the structure now from Numeric to Character means digging into code to see all areas that have been impacted - which is wuaht I may have to do ultimately. Actually, this field has no calculations at all - keeps me wondering why the previous person declared that field as a numeric one.