Need help on Type casting and removing of leading and trailing Zeros for amount column(Decimal) in DB2.
select cast(amount as VARCHAR(4000 OCTETS)) from schemaname.tablename where pay_id=1038 with ur ;
Casting function is not removing the trailing zeros.
Can you please suggest how to remove the leading and trailing zeros.
Thanks in advance!!!