Order by alphanumeric
Hi.
I want to sort the following selection list:
A1
A10
A5
BA100
BA11
BA5
alphanumerically, so that the list is first ordered by the variable
length alphabetic prefix and then by the variable length numeric
suffix, ie:
A1
A5
A10
BA5
BA11
BA100
Any idea? Note that I cannot change the strings (ie A1 to A0001, etc).
Thanks
|