Subject Re: Does FB support SQL isnull(...) ?
Author phil_sorry_trouble_with_profile
--- In, 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(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