Check out SET NULLDISPLAY TO or NVL()

>I created a cursor with
>

set null on

>
>I did some record manipulation that required the use of null values.
>
>Now i need to use the cursor to create a report.
>my report prints values like .NULL
>
>How do I get rid of the null values for reporting?
>
>can I change the cursor or do I have to create a new one?