--- In Firebird-Java@yahoogroups.com, Helen Borrie <helebor@t...> wrote:

> 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().
>
> COALESCE(AColumn, 0) returns the value of AColumn if it isn't null; if
> AColumn is null, the expression returns 0.
>
> Helen

oops, just realised this is in the wrong newsgroup... I know about the
java functions like wasNull()... I was wanting to ask this as a more
general SQL question - not specifically a java question - but it looks
like you've answered it, thanks