hi all, How we will convert Amount( in terms of Dollars) into Words . I know how to convert Amount (in Rupees) into Words and I know function module SPELL_AMOUNT . but it is not working for Decimals. Can anyone suggest solution for this. Regards Rami ReddyKnow the answer? Help other...
SET@AMOUNT=FLOOR(@RUPEES)SET@PAISE=CAST(CONVERT(DECIMAL(10,0),(@RUPEES%1)*100)ASINT)--STEP2:--NOWADDUPTHESALTANDPEPPERONTOTABLEI.E.INSERTTHEWORDSINTOITINSERTINTO@INNTBL_01SELECT'One'INSERTINTO@INNTBL_01SELECT'Two'INSERTINTO@INNTBL_01SELECT'Three'...