DYK: Sorting Numbers Gone Whacky

From Dwayne Wright
www.dwaynewright.com

Did You Know? (a series of quick discussions on things that you might have missed about FileMaker).
------------------------------------------------------------------------------------------------------
DID YOU KNOW?
SORTING NUMBERS GONE WHACKY - ( design (fields) )
If you have a field that contains numbers but it’s not sorting correctly, make sure it’s not defined as a text field. For example, say you have 10 records and the data in each is 1, 2, 10, 21, 12, 3, 30, 100, 40, 24) and you are wanting to sort in ascending order. If it is defined as a number field, it will look like 1,2, 3, 10, 12, 21, 24, 30, 40, 100). However, if the field is defined as text, the order will be 1, 10, 100, 12, 2, 21, 24, 3, 30, 40).