I have a text field that stores numbers that may occassionally have letters
after them.  I need to be able to sort this field as if it is a number field
even though it holds text.  Unfortunately, that is not something I have an
option to change, but I have to find a way to work with it.
The problem comes with the numbers 1-9 falling in the wrong place with the
text sort.
Does anyone have a suggestion on how to correct that in the sorting?  The
only thing I came up with was very messy.  That was to use nested if
statements to handle 1-9.

I am open to suggestions.

Thanks,
Beth