Sorting Alphanumeric with Numeric Numbers Question

[stann]

Hi

I have to sort numbers that are like a1, a2, a3 , a4 etc. Always a letter before a number but I can't find a way to get it to sort.

If I sort I get

A1, A11 , a2, A 20. etc.

I am not sure how to go about getting this in a sorting order

Any help is greatly needed and appreciated

Thanks

STAN

[-Queue-]

If the pattern is always one letter followed by a number, you can create a calculation field (text) of Left( field, 1 ) & Right( "000" & Right( field, Length(field) - 1 ), 3 ) and sort on that. Use as many leading zeroes as you may have digits, i.e. use 4 zeroes (and '4' as the last 'Right' parameter) if you anticipate no more than 9999 possible digits within each letter group.

[stann]

Thanks