Convert numeric to money

[Joe8915]

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

 

[rainman89]

cant you do

Format ( expression, "currency")

 

[Joe8915]

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.

 

[SOS]

SQL Side would be something like:

CAST(FieldNameHere As Money)

 

[rainman89]

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 function.