sorting by number

[mcpeekj]

i got help with formatting currency and numbers, but how do i get it so that 104,000 doesn't come before 114,000??? it sorts by the first digit but i want it to recognize where it really belongs...

 

[denoxis]

Once it's formatted it can't be considered as integer. You need to sort first then format somehow.

 

[snowboardr]

at the end of your SELECT statement put Order by number_table"

then before you write it the page format the value to whatever.

www.vzio.com