>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 :)