>>Hi All,
>>I have a list of numbers. They are not numeric, just character. When I gather them in an SQL-select statement, they go in that funny order, i.e. 4017 will come right after 40169, etc. How would I the vales in there proper order? Don't say order by because that is what I am doing now.
>>Thanks,
>
>ALLTRIM() the character field then PADL() with zeros or spaces.
>
>PADL(ALLTRIM(cNumber),11,'0')
>
>HTH,
Thanks Randy!
Winn Pauley