The index would not be optimizable but for presentation order you
could build an index on VAL(CharFld).
-myron kirby-
====================
>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.....