Natural sorting


Is it possible to have a natural ordering, so that these kind of data:
1, 1A, 2, 10, 10A, 10B, 11, 12, 20

can be fetch in this order (I use these values as the key in the dedicated view)? Because these are not numbers, they are classified as text (case sensitive, lowercase first, UTF-8 order,, and the basic order place the 10 before the 2.

I could split numbers and text and make two fields, so two keys to use in the view. But is there an other solution?

Thanks for your help.

See TO_STRING() and similar functions.