Originally posted by chrisrlong
- why do you have a column called CustNum that is a string and not a number?
Actually it can be a very good idea! Couple of real-life cases:

- Customer Number has a modulo 11 check-digit, so a valid "number" may have a T in it.

- Following several mergers, I need to incorporate some old Account Numbers without the risk of clashing with an existing one - I am going to map them 1=>A 2=>B etc.

Strictly speaking these aren't numbers - but that's what people call them.