Subject Re: [Firebird-Java] Does FB support SQL isnull(...) ?
Author Helen Borrie
At 03:52 AM 1/06/2004 +0000, you wrote:
>... I can't make it work. If it is supported, can someone indicate the
>correct syntax? (I'm looking thru help....)

IsNull() is an MSSQL function. The equivalent function in standard SQL is

COALESCE(AColumn, 0) returns the value of AColumn if it isn't null; if
AColumn is null, the expression returns 0.