Quote:
Originally Posted by theducks
Those Alpha-Numeric values should (normally) sort properly because of the leading 0's
01
05
100 < wrong, 3 characters. Make all 3 characters to avoid
20
29
all sort correctly because the ASCII weight of a 0 is less than any other digit
 Always pad 0's to make all Numeric entries the same length of digits.
In the photo, the DC special should sort AFTER the numbers since the text before this point is the same. |
I would be more than happy if when numeric fields occurred they were sorted on the absolute numeric value rather than the ascii values of the numerics..
e.g. 2 is larger than 01 and 100 is larger than 0001.
That would avoid having to include leading zeroes to get the sort correct.