Format (Apply) thousand separator in SQL Server

Hi mahesh,

Please refer below query.

SQL

DECLARE @Test AS TABLE(Id INT, Name VARCHAR(5), Salary VARCHAR(15))
INSERT INTO @test VALUES(1,'a','40000444.34')
INSERT INTO @test VALUES(2,'b','310000')
INSERT INTO @test VALUES(3,'c','400000')
INSERT INTO @test VALUES(3,'a','500000')
  
SELECT Id,Name,
	CASE WHEN Name = 'a' THEN 
	FORMAT(CAST(Salary AS MONEY),  '###,###,###.##', 'en-in') 
	ELSE Salary END 'Salary'
FROM @Test

Output