SQL format money/decimal with commas:
Sometimes you want to have your money fields properly formatted with commas like this: 13,243,543.57
You can use the CONVERT function and give a value between 0 and 2 to the style and the format will be displayed based on that
Below is an example:
DECLARE @v MONEY
SELECT @v = 1322323.6666
SELECT CONVERT(VARCHAR,@v,0) –1322323.67
Rounded [...]
Filed under: SQL Formating | Tagged: CONVERT function, Microsoft SQL server, MSSQL, MSSQL server, SQL format money/decimal with commas, SQL formatting, SQL Server | 2 Comments »









