SQL Default Return

Hi,

I have a simple SQL

SELECT DECODE(a.date, NULL, 'Date Not Exists', a.date) as Date FROM CALENDAR WHERE date = '01-JAN-2003'

'01-JAN-2003' is not in CALENDAR Table then I must expect a Default return as 'Date Not Exists'. But that doesn't work.

Anyone knows how to get this Default Return if No rows return.

Thanks Received on Tue Feb 25 2003 - 18:44:46 CST