I have a table with a field value like this:
1A
1B
..
2A
..
9A
10A
11A
11B


etc

does anyone know a sneaky way of ordering this column without resorting to a
separate sort order column or renaming 1A to 01A etc, such that 1A comes
first (ie. not after 10A)?


regards
Alan McDonald