select nvl(sum(apr),0) from crsRpt where fisyear = fy into array a1

>Thanks
>I could do it with less code just by resetting a1 = 0 each time. I just wondered if there was a way to do it inside the select.
>
>
>>ALWAYS check _tally!

>>select sum(apr) from crsRpt where fisyear = fy into array a1
>>if _tally>0
>>   replace aprTotal with nvl(a1,0)
>>endif
>>select sum(may) from crsRpt where fisyear = fy into array a1
>>if _tally>0
>>   replace mayTotal with nvl(a1,0)
>>endif
>>select sum(jun) from crsRpt where fisyear = fy into array a1
>>if _tally>0
>>   replace junTotal with nvl(a1,0)
>>endif

>>>Given a sequence like this

>>>select sum(apr) from crsRpt where fisyear = fy into array a1
>>>replace aprTotal with nvl(a1,0)
>>>select sum(may) from crsRpt where fisyear = fy into array a1
>>>replace mayTotal with nvl(a1,0)
>>>select sum(jun) from crsRpt where fisyear = fy into array a1
>>>replace junTotal with nvl(a1,0)

>>>you would think that if the select came up empty the array a1 would become null. However I find that instead of being reset to null the array simply carries over with its prior value. Is there a way to insure that it will be null if the select is empty?
>>>
>>>Thanks