replace(replace(rtrim(ltrim(replace(char(<field name>), '0', ' '))), ' ', '0'), '.', '')

is perfect for me, but my stored procedure is ko with:
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0789N The data type for parameter or variable "UPDATECPV" is not supported
in the SQL routine. LINE NUMBER=8. SQLSTATE=429BB

My <field name> is a positive number bigger than integer, do you have any idea?

best regards.