Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by EricSql
-
Comma for Thousands Separator - (*&@#$/
Terry - THANK YOU!!!! This all worked!! s-)- EricSql
- Post #7
- Forum: Microsoft SQL Server: Programming
-
Comma for Thousands Separator - (*&@#$/
That worked like a charm! But now an even better question - what if I want to use a SUM of the values and want it returned with a comma? It does not want to let me do any of the mathematical functions on it once I have converted to VARCHAR. Any ideas? Thanks.- EricSql
- Post #5
- Forum: Microsoft SQL Server: Programming
-
Comma for Thousands Separator - (*&@#$/
So this does seem to work - but how do I get it to show with no decimals? I am getting the following returned: 123,456.00 - Thanks!!- EricSql
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Comma for Thousands Separator - (*&@#$/
I am frustrated - I want to have numerical results returned with the ',' - does anyone know how to do this in SQL view?- EricSql
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Programming
