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 |
|
sross81
Posting Yak Master
228 Posts |
 Posted - 2008-05-28 : 14:30:13
|
| How do I get data that looks like 200,000 returned as a currency format? Here is what I have in my select statement it doesn't work and can't seem to find an example that works or maybe I just have it set up wrong?'$' + convert(Sum(OrderHeader.SubTotal)as money) as 'Total Sales'Ultimately I have a field that is returned and it exists on a reporting services report. I can't find a way just to format the field as currency through the properties either would that be the better way to do it if there is a way? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sross81
Posting Yak Master
228 Posts |
Posted - 2008-05-28 : 14:33:03
|
| Thanks just wanted to say I ended up finding it right after I posted.... :) |
 |
|
|
|
|
|
Format Currency