>I have a dilemna:
>I have a table of 10 character values
>example:
>0000000001
>0000000002
>0000000003
>0000000020
>
>I feed these values into a routine which takes
>the ALLTRIM(STR(VAL())) of these values. When I
>sort the resulting values, I get:
>1
>2
>20
>3
>
>I have to feed the routine with chars, so how can
>I index this table of values such that they are in
>numeric order?
>
>Thanks in advance,
>Jim Smith

INDEX ON VAL(mytable.mystring) TAG mynumbers