Subject RE: [firebird-support] put zeroes where ther are nulls in view?
Author Lee Mayhew
Check the COALESCE function...

COALESCE( field_2, 0 )

should return 0.. its the equivalent of NVL in Oracle.
-----Original Message-----
From: Martijn Tonies [mailto:m.tonies@...]
Sent: Tuesday, August 10, 2004 9:48 AM
Subject: Re: [firebird-support] put zeroes where ther are nulls in view?

> I think you are a "artificial intelligence" prototype ;) The answer was
> correct, but totally useless ...

Or it could mean "Yes, it's possible - check the documentation
that comes with Firebird 1.5, although sparse, it is in there".

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS
Upscene Productions

Yahoo! Groups Sponsor

Yahoo! Groups Links

a.. To visit your group on the web, go to:

b.. To unsubscribe from this group, send an email to:

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
Version: 6.0.734 / Virus Database: 488 - Release Date: 8/4/2004

[Non-text portions of this message have been removed]