It’s probably not a number

(the fund number database storage dilemma)

Is it a number? No. No, it isn’t a number.

With limited exceptions, if you can’t do math on it, or it’s not a sequencer of some sort, it’s not a number. Take a typical American address, for instance. One might be tempted to store the house/building number in an Integer type. That’s a silly idea. Aside from New York’s famous fractional addresses, you have alphanumeric address like 15B3 or 14C (two very real addresses…