?NVL(null,00000)
see if this works for you.



>>?NVL(null,0)
>>
>>
>>
>>>How do you get NVL() to return an integer if value is null?
>>>
>>>Thank you,
>>>
>>>Alex
>
>Thanks. What I fear is that if the first record found has a null value in a column and it is replaced with NVL(null,0), an one digit wide column is created. If later a larger integer if found it will not fit in the column. At least I used to find that problem inf FPDos (not with nulls, of course). Maybe it has long been fixed.
>
>Alex