DSXchange

I have a small issue,I have a flat file as source it has an amount column like the scenario is
flat file amt column :14560
database amt column :145.60

so i need to populate the data in the target database like 145.60,i have put /100 to the amt column it populates as 145.6 but i need as 145.60 please help me out
Awaiting for your help

Oconv(14560, "MR2") or Fmt(14560, "MR2") will do the job for you.

so I need to give the function like
oconv(amt column,"MR2")
Is it true so that all the data in that amt coulumn will be in decimals

Hi Rafi,
To add one more to ray's soln
FMT("flat file amt column/100", "L2").



Regards
kcs