Money Data Type: Want 2 Decimal Places - Not 4

[SeaninSeattle]

I'm using the Money Data Type becuase I need an automated email to spit out dollar amounts. Do any of you have any idea how I use the Money Data Type to show it with 2 decimal places instead of 4? Am I wrong to use this data type - should I be using something else?

Thanks in advance!

//sse

Sean Engle
Admin/DirIS
ssengle@bswusa.com

 

[ClaireHCM]

yes....use

convert(decimal(6,2),money_column_name)

 

[SeaninSeattle]

Great - thank you. Any idea on how I get the currency symbol to appear?

Thanks,
//sse

Sean Engle
Admin/DirIS
ssengle@bswusa.com

 

[ClaireHCM]

Are you saying adding "$" in the front?If yes....then

select '$'+convert(varchar,convert(decimal(5,2),column_name)) from table_name