Best way to remove leading zeros and trailing decimal point in DB2 v7.x?

[Trent]

Hello, everyone.

I need to remove leading zeros and a trailing decimal point.
current data: 000000012345. The leading zeroes are ranging from 1 to 9
zeros.
desired data: 12345
One field has decimal data type not null.
The second field has char data type.

I heard of STRIP function.
I want to use DML to export and filter the data to a ixf file and
import replace the current data.

Please advise.

Thanks

Trent

[Blair Kenneth Adamache]

db2 values cast (000000012345. as int)

1
-----------
12345

1 record(s) selected.