Hi, the following select select decode (date, null, '2099-12-31', date) from dual
returns 20061106 Why not a date? I have reduced my original select that has left joins where I want to replace null values by defined values. I actually use this work around: select decode (date, null, '2099-12-31', chr(year(date))&'-'&chr(month(date))&'-'&chr(day(date))) from dual or could use function value() But shouldnt it work ? Elke Mit freundlichen Grüßen Elke Schmidtke Ministerium für Bildung, Jugend und Sport Tel.: 0331/866-3664 Fax: 0331/27548-2586 e-Mail: [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
