thanks.

cast(ccode as decimal(5,2)) is not working. I had to use following.

cast(convert(float,ccode) as decimal(5,2)). this has got me my results. hope this is what you guys are doing same to convert string to val.