Sort Numbers as Numeric

[Michael Mantkowski]

I have a list of values in a character field like this.

A1
2
1
B2
20
12

It Sorts like this.

1
12
2
20
A1
B2

I want it to sort like this.

1
2
12
20
A1
B2

Seems like I should know how to do this, but it is not coming to me this morning...

Any help?

Thanks!!

*********************************************************************
Michael Mantkowski
ClienTrax Software
1-614-875-2245
*********************************************************************