Sort Order

The field type determines the results of 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.