PADL(ALLTRIM(myfiled), < field len >, '0')

>How do I sort a table on a numerical field so that I get the following:
>
>1
>10
>100
>101
>102
>1001
>1002
>etc...
>
>as opposed to this:
>1
>10
>100
>1001
>1002
>101
>102
>etc....
>
>Thanks in advance for your help,
>Russell