Subject Re: [firebird-support] Null to Zero conversion
Author Paul Vinkenoog
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".

If your view is updatable, you can use:

update myview set myfield = 0 where myfield is null

If not, make it updatable using triggers.

If you only want to _see_ 0 instead of null (not updating the
underlying table) you could use an SP, or maybe CASE (in FB 1.5).

Paul Vinkenoog