you create a calc field which will be the secon last digit Middle(thevalue;length(thevalue)-2;1) and you do your sort on this calc field
I too have been wondering if this was possible!
I am still a little bit confused by what you mean by "second last digit middle (thevalue ; kength (the value) -2;1)" could you possibly give an example using the numbers above?
You create a calculation field (in manage database / fields)
you name is "whatyouwant"
you define it as
Middle(thevalue;length(thevalue)-2;1) this is the cacl field formula
then, when you want to sort, you sort upon the field "whatyouwant"