>>Integer to numeric? Then padl(myNumField,10,'0')+dtos(). Numerics didn't sound as an id to me and couldn't determine such a usage.
>>Cetin
>
>I'm not talking about IDs anymore.
>
>I defined a new simple problem:
>
>Have a numeric field (not an ID) in the ascending order and the date field in the descending order.
>
>Both fields may be blank or null.
>
>Don't use a select statement :)
padl(iF,20)+trans(int(99999999-VAL(DTOS(nvl(dF,{})))))
Cetin