Demo 1 Demonstrates adding commas: [sql] PRINT FORMATMESSAGE('The number is: %s', format(5000000, '#,##0')) [/sql] -- Output The number is: 5,000,000 Demo 2 Demonstrates commas and decimal points. Observe that it rounds the last digit if necessary. [sql] PRINT FORMATMESSAGE('The number is: %s', format(5000000.759145678, '#,##0.00')) [/sql] -- Output The number is: 5,000,000.76 Compatibility SQL Server 2012+.