Print Page - NULL conditions for a data item in a query

Title: NULL conditions for a data item in a query
Post by: sreejithhk on 09 May 2012 04:41:43 AM

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.

Title: Re: NULL conditions for a data item in a query
Post by: blom0344 on 09 May 2012 05:14:57 AM

Cognos can use coalesce to replace null values..

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: sreejithhk on 09 May 2012 04:41:43 AM