I have a field that's Character(10), but
it's full of numbers. Problem is that
when I set an order to the field it
sorts like:
1
2
20
21
3
4
Needless to say, I'd like it to be
1
3
4
20
21

I don't want to have to change the
structure of the table because that will
force me to change A LOT of code. (A
couple of weeks worth of work).

Any suggestions on how I can get this to
sort the way I want? (Using VFP 5.0)

Thanks.....