Is there a way to sort alphanumeric fields so they sort like this:

1
2
100

Rather than this:

1
100
2

are you using this in a search or somewhere else? you could try sorting twice. First by length, then by value. but not totally sure how you'd do that in a search. that's a problem when storing numbers in a form other than integer, decimal, etc.