Hi Cavit,

> > I have a view returning null values because of left join but I want
> > to replace null values with 0's. I cannod find any way to do this. I
> > think there is no function like IsNull(). I tried using union but I
> > get an error message of "datatype unknown".

With Fb1.5 - use COALESCE, which can do an IsNull.

Or use an UNION with:

CAST(NULL as <datatype of your column>)


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com