|Subject||RE: [firebird-support] How to cast a float?|
> select cast(depreciation_rate as integer) || '%' from my_table
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.