Convert the column to money

• vigneshkumart50

  Ten Centuries

  Points: 1205

  More actions

  March 20, 2014 at 6:48 am

  #305444

  Hi,

  cast(round([YearlyProfit]-[MonthlyProfit],0)as int),

  cast(round(isnull(sum(SalesProfit]),0),0) as int

  How can I convert these columns to money so that I can display the result with comma included.

• djj

  SSCoach

  Points: 18831

  More actions

  March 20, 2014 at 7:04 am

  #1698667

  On BOL look at "Cast and Convert (Transact-SQL)" see "money and smallmoney Styles"