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
To: firebird-support@yahoogroups.com
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
SQL
Server.
Upscene Productions
http://www.upscene.com


Yahoo! Groups Sponsor
ADVERTISEMENT





----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

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 (http://www.grisoft.com).
Version: 6.0.734 / Virus Database: 488 - Release Date: 8/4/2004


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