>
> select cast(depreciation_rate as integer) || '%' from my_table

Try
select cast(depreciation_rate as varchar(10)) || '%' from my_table

I tried it on a couple of fields in one of my db's and got the same error
because I had not casted to a long enough variable. Made it longer (
VarChar(10) ) and it worked.

Lee