While cast to decimal may have worked in this instance, I think looking at the table definition and changing the underlying datatype there would be a better option - assuming you have the "power" to do so.

I appreciate it may be too hard/risky/politically impossible to do so.

Mike John