Print Page - Text Blob Conversion

Title: Text Blob Conversion
Post by: naveen_hadagali on 08 Dec 2008 06:56:36 AM

Hi All,

I am working on cognos 8.1 and we have a field with datatype Text blob ,i want to convert it to Varchar or char .How to acchieve convertion of textblob to Varchar/char in cognos.

Thanks in advance

Regards
Naveen

Title: Re: Text Blob Conversion
Post by: Gopinath on 09 Dec 2008 02:38:54 AM

Try using CAST

cast([Data Item] as varchar(length))

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: naveen_hadagali on 08 Dec 2008 06:56:36 AM