----- 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)

Regards,
Przemek.