Sorting lets you process records and generate the resulting output in either ascending or descending order based on the values in the specified field.
The in order operator sorts records in sequence from least to greatest value based on the type of field as follows:
Text: alphabetical order (A-Z)
Number: least to greatest numerical value
Date: earliest to latest date
Time: earliest to latest time
Choice: lowest to highest numbered choice
Example
The output from this script might look as follows:
Club Name
Bora Bora
Buccaneer's Creek
Cancun...
Uxmal
The in reverse operator sorts records in greatest to least sequence. For example, if we change the script to:
CLUB NAME in reverse .
The output is reversed:
Club Name
Uxmal
Turkoise
Teotihuacan...
Bora Bora