>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,