I have a database with records 1-9999. When I list them out, they dont sort correctly. 200 is before 1000, but listed out 1000 comes first. Any ideas how to change the sort by line? Thanks for any help!
You mean:
"...sort by field asc" "...sort by field desc"
Makes searches up and down, or down and up...
I already have this statement, but it does not sort them in numerical order. Yes they are in order according to their first number (1000, 234, 567, 999), but not actual numerical order(234, 567, 999, 1000) I'm not sure how to do this.
is the field a some kind of string field?
It sounds like the field is a string (CHAR) type rather than a numeric (INT) type.
Change the column definition.
Thank you Mike. Yes the field was designated as a CHAR type....so I changed it to INT and everything is fine now. I appreciate the help!
