— select dbo.fnNumberToWords(2323422435);<\/p>\n
<\/p>\n
Alter FUNCTION fnNumberToWords(@Number as BIGINT)\u00a0 RETURNS VARCHAR(1024)<\/p>\n
AS<\/p>\n
BEGIN<\/p>\n
DECLARE @Below20 TABLE (ID int identity(0,1), Word varchar(32))<\/p>\n
DECLARE @Below100 TABLE (ID int identity(2,1), Word varchar(32))<\/p>\n
INSERT @Below20 (Word) VALUES<\/p>\n
( ‘Zero’), (‘One’),( ‘Two’ ), ( ‘Three’),<\/p>\n
( ‘Four’ ), ( ‘Five’ ), ( ‘Six’ ), ( ‘Seven’ ),<\/p>\n
( ‘Eight’), ( ‘Nine’), ( ‘Ten’), ( ‘Eleven’ ),<\/p>\n
( ‘Twelve’ ), ( ‘Thirteen’ ), ( ‘Fourteen’),<\/p>\n
( ‘Fifteen’ ), (‘Sixteen’ ), ( ‘Seventeen’),<\/p>\n
(‘Eighteen’ ), ( ‘Nineteen’ )<\/p>\n
<\/p>\n
INSERT @Below100 VALUES (‘Twenty’), (‘Thirty’),(‘Forty’), (‘Fifty’),<\/p>\n
(‘Sixty’), (‘Seventy’), (‘Eighty’), (‘Ninety’)<\/p>\n
<\/p>\n
declare @belowHundred as varchar(126)<\/p>\n
<\/p>\n
if @Number > 99 begin<\/p>\n
select @belowHundred = dbo.fnIntegerToWords( @Number % 100)<\/p>\n
end<\/p>\n
<\/p>\n
DECLARE @English varchar(1024) =<\/p>\n
<\/p>\n
(<\/p>\n
<\/p>\n
SELECT Case<\/p>\n
WHEN @Number = 0 THEN\u00a0 ”<\/p>\n
<\/p>\n
WHEN @Number BETWEEN 1 AND 19<\/p>\n
THEN (SELECT Word FROM @Below20 WHERE ID=@Number)<\/p>\n
<\/p>\n
WHEN @Number BETWEEN 20 AND 99<\/p>\n
THEN\u00a0 (SELECT Word FROM @Below100 WHERE ID=@Number\/10)+ ‘-‘ +<\/p>\n
dbo.fnIntegerToWords( @Number % 10)<\/p>\n
<\/p>\n
WHEN @Number BETWEEN 100 AND 999<\/p>\n
THEN\u00a0 (dbo.fnIntegerToWords( @Number \/ 100)) +’ Hundred ‘+<\/p>\n
Case WHEN @belowHundred <> ” THEN ‘and ‘ + @belowHundred else @belowHundred end<\/p>\n
<\/p>\n
WHEN @Number BETWEEN 1000 AND 99999<\/p>\n
THEN\u00a0 (dbo.fnIntegerToWords( @Number \/ 1000))+’ Thousand ‘+<\/p>\n
dbo.fnIntegerToWords( @Number % 1000)<\/p>\n
<\/p>\n
WHEN @Number BETWEEN 100000 AND 9999999<\/p>\n
THEN\u00a0 (dbo.fnIntegerToWords( @Number \/ 100000))+’ Lacs ‘+<\/p>\n
dbo.fnIntegerToWords( @Number % 100000)<\/p>\n
<\/p>\n
WHEN @Number BETWEEN 10000000 AND 999999999<\/p>\n
THEN\u00a0 (dbo.fnIntegerToWords( @Number \/ 10000000))+’ Crore ‘+<\/p>\n
dbo.fnIntegerToWords( @Number % 10000000)<\/p>\n
<\/p>\n
WHEN @Number BETWEEN 1000000000 AND 99999999999<\/p>\n
THEN\u00a0 (dbo.fnIntegerToWords( @Number \/ 1000000000))+’ Arab ‘+<\/p>\n
dbo.fnIntegerToWords( @Number % 1000000000)<\/p>\n
<\/p>\n
\/*\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WHEN @Number BETWEEN 1000000 AND 999999999<\/p>\n
THEN\u00a0 (dbo.fnIntegerToWords( @Number \/ 1000000))+’ Million ‘+<\/p>\n
dbo.fnIntegerToWords( @Number % 1000000)<\/p>\n
<\/p>\n
WHEN @Number BETWEEN 1000000000 AND 999999999999<\/p>\n
THEN\u00a0 (dbo.fnIntegerToWords( @Number \/ 1000000000))+’ Billion ‘+<\/p>\n
dbo.fnIntegerToWords( @Number % 1000000000)<\/p>\n
*\/<\/p>\n
ELSE ‘ INVALID INPUT’ END<\/p>\n
)<\/p>\n
<\/p>\n
SELECT @English = RTRIM(@English)<\/p>\n
<\/p>\n
SELECT @English = RTRIM(LEFT(@English,len(@English)-1))<\/p>\n
WHERE RIGHT(@English,1)=’-‘<\/p>\n
RETURN (@English)<\/p>\n
END<\/p>\n
Get Files<\/a><\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" — select dbo.fnNumberToWords(2323422435); Alter FUNCTION fnNumberToWords(@Number as BIGINT)\u00a0 RETURNS VARCHAR(1024) AS BEGIN DECLARE @Below20 TABLE (ID int identity(0,1), Word varchar(32)) DECLARE @Below100 TABLE (ID int identity(2,1), Word varchar(32)) INSERT @Below20 (Word) VALUES ( ‘Zero’), (‘One’),( ‘Two’ ), ( ‘Three’), ( ‘Four’ ), ( ‘Five’ ), ( ‘Six’ ), ( ‘Seven’ ), ( ‘Eight’), ( ‘Nine’), ( ‘Ten’), ( ‘Eleven’… Read more →<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"class_list":["post-355","post","type-post","status-publish","format-standard","hentry","category-sql","xfolkentry"],"_links":{"self":[{"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/355","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=355"}],"version-history":[{"count":0,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/355\/revisions"}],"wp:attachment":[{"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=355"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=355"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}