Paul Beach wrote:

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

You can always avoid NULLs :)

http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci784090,00.html