Displaying results as currency

I'm looking to display the results of the following query as currency. Any help with this would be greatly appreciated...
SELECT SUM (sysTotalCharge) - SUM (sysTotalCredit) AS TotalNet FROM Bookings WHERE (sysRecordDate BETWEEN '01/01/::Year::' AND '01/31/::Year::')It's a presentation layer issue...

But you could look up CONVERT

What do you want it to look like?|||I looking for it to be formatted thusly...

$999,999.00