Hi,

At August 10, 2004, 10:36, Jorge Andrés Brugger wrote:

> Hi.

> I´ve a view with a left join between two tables, and I want to return 0
> instead of null on a field of the second table. Is this posible?

> Actual result set:
> Field_1 Field_2
> 1 1
> 2 2
> 3 null

> and I want:
> 1 1
> 2 2
> 3 0

If you are using FB 1.5, you can use COALESCE to return the value 0
instead of NULL. Look in the release notes for all the information.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)