by billberet on Sat Jan 14, 2012 5:00 pm hey, before i go and edit all my databases, i have a sorting question.
for my tv episode database, i number all episodes, makes it easy when i have to go to episode 234 of trek. (showing my geekness)
currently between 1-100 i pad with only one zero
01,02,03,04...10
but when i sort now the 100's and 200's get in the way.
currently my sorting looks like this
06,07,08,09,10,100,101,102.....
16,17,18,19,20,201,202,203.....
26,27,28,29,30,300,301,302.....
if i pad with 2 zero's i'm fine
007,008,009,010,011,012,013....100,101,102
before i go into all my thousands of records and pad a zero to every one, is there any other route i can be going to have it sort correctly?
|
