Skip to main content

Sorting mixture of numbers and letters

  • September 12, 2021
  • 1 reply
  • 7 views

Forum|alt.badge.img+13

How does AT sort (address) numbers that also have a suffix letter? For example, 2A, 2B, etc.

To overcome the sorting problem for addresses in a Filemaker desktop database I use, I have a separate field alongside the address number in which I enter the address number in numerical formal only and use that separate field for sorting. For example, 2.1, 2,2, etc.

tia

1 reply

Forum|alt.badge.img+13
  • Author
  • Inspiring
  • September 12, 2021

Answered my own question. AT sorts 2, 2B, 2A, 2C as 2, 2A, 2B, 2C.
so no need for separate field.