Hi Bharti,
Thanks for your response. This does display commas in the table view. Am I correct in assuming that in order for this to work, I have to set the table view column datatype to text. Is there any way to display table view decimal or integer columns with commas? I actually have a number of excel formulas that reference the table view columns and they no longer work when the data type of the columns is set to text.
This would work for decimal columns:
| SELECT CONVERT( numeric(10,1), 5634.6334) as number | 5634.6 |
| SELECT CONVERT( numeric(10,2), 5634.6334) as number | 5634.63 |
Source: https://www.mssqltips.com/sqlservertip/7021/sql-format-number/
Please let me know if you have additional queries.
