Convert numbers to pre-defined letters - to create...

[Michael_Lever]

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

[Michael_Lever]

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