>>>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
Good idea to use BigNumber - val(dtos()) instead of BigDate - date (which I found doesn't work for empty dates, unless you convert them first to the same big date).
If it's not broken, fix it until it is.
My Blog