Punctuating Long Numbers
Top  Previous  Next

The following example shows how you can use the FORMAT function to include a comma after the thousand's place:

SELECT (FORMAT(transid,'999,999')) FROM transmaster  
 
The following shows the effect of the FORMAT function on the above SELECT statement:

Using FORMAT
Without FORMAT
104
104
2,002
2002
39,765
39765