ckd_amt is an amount value field and the format is ->>>>,>>>,>>9.99 (10 decimal place...) requirement is ..
say ckd_amt has a value... ckd_amt = 297.63 .. first i need to remove the decimal by multipying 100...
297.63 * 100 = 29763... now.. lpad zeros to length 10... so the value should be ...