Text Blob Conversion

[naveen_hadagali]

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

[Gopinath]

Try using CAST

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