cannot get rid of decimal point -Reply

[Mark Kraft <kraftm@GUNET.GEORGETOWN.EDU>]

First, move it to a string, i.e.  Move #var to $var 099999999 with out the
decimal point, then you should be able to lpad without a problem

Mark Kraft
kraftm@gunet.georgetown.edu

>>> Charu Srinivas <C._Srinivas/dsisys/US@DSISYS.COM> 10/28/98
03:41pm >>>
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