Thanks everyone.

Just out of curiosity, how come coalesce didnt work?

Thanks again, Matt.

That worked perfectly.

Regards,

Afkas

Thanks, Matt.

I know for each row, it will return only the non-Nulls.

But my problem is that for all other rows which are non-Nulls, the query produces 0 as the...