NULL conditions for a data item in a query

[sreejithhk]

Hi,

How can we append values(Default values) if columns have NULL values as we do in Database (ISNULL in SQL server) for a data item in a query.

We have a function NVL for oracle in cognos.. how to handle this in SQL server 2008.

[blom0344]

Cognos can use coalesce to replace null values..