Sort Order
The field type determines the results of the sort. If the field stores alphanumeric data (such as an ID field) any digits are treated as characters.
Text and text that includes numbers are sorted in the following Ascending order:
space ! ” # $ % & ’ ( ) * + , - . / : ; < = > ? @ [ \ ] ^ _ ` { | } ~ 0 1 2 3 4 5 6 7 8 9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
For example, Alphanumeric IDs ascending results:
A1
A111
A12
A2
Numbers are sorted in Ascending order from the smallest negative number to the largest positive number.