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.
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman