SQL Server - Formatting Number

 If we want to format number with comma in SQL server query..

Suppose number is 12345678 and we want to present it as 1,23,45,678

Use following command..

SELECT FORMAT(12345678, 'N0', 'en-IN')