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@WORD=(SELECT@WORD+MTEXT+''FROM@INNTBL_02WHERERECNO=@M_AMT01)ENDIF@AMOUNT<=20AND@AMOUNT>=1BEGINSET@WORD=(SELECT@WORD+MTEXT+''FROM@INNTBL_01WHERERECNO=@AMOUNT)END--Change --SET@WORD=@WORD+'rupees' SET@WORD=@WORD+''--STEP4:--CALCULATETHEPAISEALSO.DECLARE@WORDPVARCHAR(300)SET@WO...
Set @Return = @Return + 'Rupees And ' + dbo.GetTextValue(SubString(@Dec,2,2)) + 'Paise Only' ELSE Set @Return =@Return+'Zero Rupees Only' Return @return End - CREATEFunction [dbo].[GetTextValue] ( @dblNumber Numeric ) Returns Varchar(1000) As Begin Declare @StrWord Varchar(4...