Testing DATE for NULL value?

[Netherbeast]

Im tring to test a column CURRENT that has DATE values. I want to print "NO DATE" when there is no date. How do you test for null in this case?

Thanks in advance

 

[sem]

select nvl(to_char(CURRENT),'NO DATE') from <TABLE>

Regards, Dima

http://seminihin.narod.ru

 

[NITIN27]

HI
IF CURRENT IS NULL THEN
CURRENT:='NO DATE'
END IF;

THIS U CAN WRITE IN TRIGGER