Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Currency format from a sum in a query
Message
From
27/11/2008 01:50:56
Sergey Berezniker
New York, United States
 
 
To
26/11/2008 22:43:55
Edgar Salcedo
Bogotá, Colombia
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Re: Currency format from a sum in a query
Environment versions
SQL Server:
SQL Server 2005
Application:
Web
Miscellaneous
Thread ID:
01364335
Message ID:
01364351
Views:
7
>when I use sum(propuesta.presupuestocop) the result is for instance 47283.0000 and I want to display $ 47,283
CAST(sum(propuesta.presupuestocop) AS Money)
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform