Page 1 of 1

sorting issue, have to pad zero's

PostPosted: Sat Jan 14, 2012 5:00 pm
by billberet
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?

Re: sorting issue, have to pad zero's

PostPosted: Sun Jan 15, 2012 6:48 pm
by billberet
long nights of adding 0's
everything is sorting great :)