decimals

[rafidwh]

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

[ray.wurlod]

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

[rafidwh]

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

[kcshankar]

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



Regards
kcs