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]