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
but when i sort now the 100's and 200's get in the way.

currently my sorting looks like this

if i pad with 2 zero's i'm fine

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 :)