Can you use union
like
select col1, col2, 0 where col3 is NULL from table unioun
select col1, col2, col3 where col3 is NOT NULL from table

----- Original Message -----
From: "Cavit Aladag" <aladag@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, August 28, 2003 5:11 PM
Subject: [firebird-support] Null to Zero conversion


> Dear friends,
>
> 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".
> Anybody has a suggestion?
>
> My regards,
> Cavit Aladag
>
> [Non-text portions of this message have been removed]
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>