Epicmanagement
asked on
SQL. Format the dollar amount to include a comma.
SQL. SQL 2000
How do I format a dollar amount to include the commas:
I have this statement:
Select '$' + CONVERT(varchar(12), CAST(isnull(sum(totvalue), 0) as numeric(10,2) )) from vwtotvalue
Which returns $13892.32 , but I would also like it to have the commas: $13,892.32
How do I format a dollar amount to include the commas:
I have this statement:
Select '$' + CONVERT(varchar(12), CAST(isnull(sum(totvalue),
Which returns $13892.32 , but I would also like it to have the commas: $13,892.32
ASKER
NO. That didn't return any commas.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Select '$' + CONVERT(varchar(12), convert(money,coalesce(sum