|
what about stroring the phone numbers as 3 seperate integer values (area code, prefix, suffix)? So the number (410)321-1234 would be stored with an area code of 410, a prefix of 321, and a suffix of 1234. You could then sort by each of those columns...
Maybe I'm missing an obvious downfall, but it seems like it would make the sorting easier.
__________________
Greetings and salutations.
|