Converting String To Decimal

[benchpolo]

I have a column SUBAMOUNT where the value is converted to text 0000008917'. When the file is received I need to convert it to decimal (0000008917 converted to 89.17. I tried to use the CAST TSQL command, but it is giving me a result of 8917.00, which is incorrect.

Thanks in advance for your assistance.

[Delerna]

convert(decimal (18,2),SUBAMOUN T)/100.0

[benchpolo]

I'm getting an arithmetic overflow once I insert it to sql where the column data type is decimal (8,2).
Please advise.

[gpl]

convert(decimal(8,2),SUBAMOUNT)/100.0

[NeoPa]

Let's not waste time here.

Why don't you post the code you already use, that returns a value of 8917, then we can see how safely, in those particular circumstances, this value can be divided by 100.