Hi,

At December 11, 2003, 11:05, Marc Geldon wrote:

> and why does it work with mySQL NULL = NULL but NULL + 1 = 0!

MySQL doesn't follow the standard. Because, according to the SQL
standard: NULL + 1 = NULL.

Try FB 1.5. There has been new functionality(CASE and COALESCE)
that was added that would permit you to do what you want. You only
need to use one of them. You can read the release notes for further
details on how to use them.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)