Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ironwood9
Starting Member
1 Post |
 Posted - 2012-01-31 : 14:45:00
|
| I am fairly new to T-SQL I have a column in my table "Net_Revenue" - i'm trying a simple, basic SELECT query which includes that field, but the numbers come out without commas - how do I have the numbers show up with commas ? |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2012-01-31 : 14:48:55
|
| The reporting app or front end app should apply thousand separator formatting, not the db queryDuane. |
 |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2012-01-31 : 15:10:20
|
| Duane is correct that this is a display issue and should be handed by whatever is displaying the data. But, since you are new to SQL Server you might want to investigate the CAST and CONVERT functions. The CONVERT function will allow you to convert between datatypes and specify a format. Here is a link to Books Online (BOL) for Cast and Convert:http://msdn.microsoft.com/en-us/library/ms187928.aspx |
|
|
|
|
|
|
Number data type 1 - comma separator