SQL Default Return

[Quoted] I have a simple SQL

[Quoted] [Quoted] SELECT DECODE(a.date, NULL, 'Date Not Exists', a.date) as Date FROM CALENDAR [Quoted] 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 Wed Feb 26 2003 - 01:44:46 CET