| Subject | Re: [Firebird-Java] Does FB support SQL isnull(...) ? |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-06-01T06:48:11Z |
At 03:52 AM 1/06/2004 +0000, you wrote:
COALESCE().
COALESCE(AColumn, 0) returns the value of AColumn if it isn't null; if
AColumn is null, the expression returns 0.
Helen
>... I can't make it work. If it is supported, can someone indicate theIsNull() is an MSSQL function. The equivalent function in standard SQL is
>correct syntax? (I'm looking thru help....)
COALESCE().
COALESCE(AColumn, 0) returns the value of AColumn if it isn't null; if
AColumn is null, the expression returns 0.
Helen