I'm probably the world's biggest fan of the Tally table... keep that in mind when I say that Tally table solutions are probably not appropriate nor as fast...
What I forgot to mention was that these member "numbers" are alphanumeric and will always have a prefix containing two letters of some sort. Can this...