Formatting recordset variables in ASP

Help I have an ASP page that call a function that writes recordset data in to a table that's displayed. It returns a recordset variable that I add a formatting mark to and let fly into the table. For example I do the following:

Response.Write "<td align=right>" & chr(36) & rs0.Fields("YTDAppliedSales") & "</td>" & vbCrLf

Chr(36) makes that currency mark that I need.

I need to format the variable in such a way that it also will have a comma when it needs one (at every 3 place). That way I don't end up with $1000.00. I would end up with $1,000.00. Any ideas?

Have you tried FormatCurrency() function available
in VB scripting ?