View Single Post

  #1 (permalink)  
Old 05-08-2008
Asteras Amaliadas
 
Posts: n/a
Default 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
Reply With Quote