Round number off and change to currency

[dhutton]

Hello -

Question... What would be the best way to round a number off and change it to currency with the below statement?

SELECT Cycle AS BillCycle, SUM(PrevBillAmt) - SUM(Payment) + SUM(Adjustment) + SUM(LocServCharge) + SUM(OtherChgCred) + SUM(TotalTaxes) + SUM(TollCharge) AS Total,

**** My result is this:

2241661.6600

**** And want to change it to this:

$2241661.66

or even this will work, rounding up or down

$2241662

Thanks!

[azimmer]

Hello -

Question... What would be the best way to round a number off and change it to currency with the below statement?

SELECT Cycle AS BillCycle, SUM(PrevBillAmt) - SUM(Payment) + SUM(Adjustment) + SUM(LocServCharge) + SUM(OtherChgCred) + SUM(TotalTaxes) + SUM(TollCharge) AS Total,

**** My result is this:

2241661.6600

**** And want to change it to this:

$2241661.66

or even this will work, rounding up or down

$2241662

Thanks!

select '$'+cast(round(Total,0) as varchar(24))
 

Note: you can put in an extra select whose FROM clause is your SELECT statement