Subject Re: [firebird-support] NULL Date values
Author Nando Dessena
Martijn,

M> Perhaps you could use a COALESCE(MyColumn, DateToStr(MyColumn), '')
M> to work around the display problem?

I think it would have to be

case when mycolumn is null then '' else datetostr(mycolumn) end

instead.

P.S. I assume the library doesn't use UDF descriptors, in which case it
will be hard to have it recognize NULLs.

Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================