Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: nfldbunker on 10 Nov 2009 12:38:44 PM

Title: using Cast
Post by: nfldbunker on 10 Nov 2009 12:38:44 PM
hi

do anyone know th format (structure) of using the cast funtion to convert a field from varchar(10) to and int

regards
bunker
Title: Re: using Cast
Post by: blom0344 on 11 Nov 2009 03:39:06 AM
cast([somestringrepresentinganinteger],integer)

will fail if it encounter a format that it cannot convert
Text only | Text with Images