cannot get rid of decimal point

[Charu Srinivas <C._Srinivas/dsisys/US@DSISYS.COM>]

Hi everyone,

I am using Oracle and SQR.

I m trying to create a flat file with values from the PeopleSoft table. One
of the fields is numeric. I want it to look like 9(7)V99
i.e without any decimal points and it should be left padded with zeros.(
e.g 12.54 should look like 000001254)
Then I move it to a character variable so that i can write it to the flat
file.

I tried using move #var to $var 0999999V99 but it gives me a decimal point
and right pads it with zeros i.e
12.54 looks like 12.5400000

If any of you have suggestions, I would greatly appreciate it.

Thanks in advance -Charu