>Just my opinion, but fields that will have not have mathematical calculations performed on them should not be numeric even if they consist of all digits. They should be character.
I agree 100%. Someone taught me this rule early in my programming career, and I've applied it ever since without running into any need for exceptions.
Rick Borup, MCSD
recursion (rE-kur'-shun) n.
see recursion.