sort -- number with letters
I've got a field that always has numbers, but also occasionally has letters.
I'd like it to sort so that the numbers are always in order, but that when the letters appear, those sort as well.
101, 100, 103, 101A, P103, 101C, 101b, 103A
would sort as follows:
If I make the field a NUMBER field, it ignores all the letters completely.
If I make it a TEXT field, it sorts everything correctly, but puts the "P" prefixes at the end of the list.
I invite your thoughts.