Convert number in Indian currency format in SQL Server

Dear @moni,

Please try below query, it might be help you

DECLARE @BigNumber BIGINT
SET @BigNumber = 1234567891234

SELECT REPLACE(CONVERT(VARCHAR,CONVERT(MONEY,@BigNumber),1), '.00','')

Result : 1,234,567,891,234

Please refer below article,

https://www.sqlmatters.com/Articles/Formatting%20a%20number%20with%20thousand%20separators.aspx

https://www.sqlservercentral.com/Forums/Topic1145424-1292-1.aspx

http://www.aspforums.net/Threads/150473/Format-number-and-add-Comma-after-two-digits-in-Currency-using-C-Net/