> I have a problem with "NULL". If I run a statement like SELECT CAST(NULL AS

INTEGER)+1 AS NUMMER FROM WHATEVER the result is NULL!

>
> That's a problem. I had a SQL which was running on mySQL. Some sort of:
>
> INSERT INTO WHATEVER (NUMBER, USER)
> SELECT (MAX(NUMBER)+1) AS NUMBER,
> "a name" AS USER FROM WHATEVER
>
> 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?

You don't - as per the SQL standard NULL=NULL=NULL

Regards
Paul