sorting issue, have to pad zero's

V3 help and support questions

sorting issue, have to pad zero's

Postby 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?
Image
billberet
 
Posts: 738
Joined: Mon Sep 29, 2008 9:26 pm
Location: NYC

Re: sorting issue, have to pad zero's

Postby billberet on Sun Jan 15, 2012 6:48 pm

long nights of adding 0's
everything is sorting great :)
Image
billberet
 
Posts: 738
Joined: Mon Sep 29, 2008 9:26 pm
Location: NYC


Return to Support

Who is online

Users browsing this forum: No registered users and 3 guests

cron