|Subject||Re: [Firebird-general] Problems with NULL|
----- Original Message -----
From: "Marc Geldon" <Geldon@...>
Subject: [Firebird-general] Problems with NULL
> In mySQL it worked very well. In FB not! He tells me something about
datatype not known and so on. Also a CAST AS INTEGER does not work. How can
I convert this NULL into a 0?
Hi Marc, in FB 1.5 You can try this: COALESCE(MAYBE_NULL_VALUE_??, 0)