Cognos 8.4 Report Studio cast character as number

[CrystalLion]

In Report Studio, I have created a data item that equals only the digits found in a Character field, such as If([Additional Information] contains '4') then ('04') else (...etc.

I would like to cast this result as an integer, and compare it to the dd portion of a DATE_TIME field.

What would the syntax be for this.

 

[blom0344]

case
when [additional information] contains '4' then 4
when [additional information] contains '5' then 5
....
else 0 end

Beware the order in which the case is build decides which value is returned

So ,the string 54 yields 4 since the '4' option is evluated before the '5' option..

Ties Blom