If the column is an alphanumeric one, then the contents will be sorted alphabetically, not numerically. This will mean that the information in the column will be compared left to right and so the length of the string will affect how it is handled.
Not sorting as expected
I have a column with numbers but it sorts in a strange order
Written by Alina Stepanek