Being very new and I mean very new to SQL. I am trying to Convert numeric to money. I have a cell with Dollar Amts. When I excute the query the dollar amts come over as a numeric.

Sample:
13525.00

Convert to
$13,525.00

How do I do it?

Thanks

cant you do

Format ( expression, "currency")

rainman, thanks for the reply. When you say format the expression as currency. Are you saying that can be done on the SQL side, and if so where do I insert the expression I don't see it on the drop down for the data type on the SQL side.

SQL Side would be something like:

CAST(FieldNameHere As Money)

Sorry Joe. I didn't see that you wanted the SQL version!!

SOS's solution should work for you. If not you might want to look up the convert (http://msdn.microsoft.com/en-us/library/ms187928.aspx) function.