issue casting as dollars, etc.

• jeffshelix

  SSCrazy

  Points: 2257

  More actions

  May 10, 2018 at 8:03 am

  #403329

  I would like this to output as

  1. With Dollar signs
  2. Thousand separators
  3. Whole dollars amount with no decimals.

  Thanks

  cast(L.HTS_Value as money) as [Original Line_Value]

• Thomas Rushton

  SSC-Insane

  Points: 22649

  More actions

  May 10, 2018 at 8:08 am

  #1990048

  This is something that would normally be done at the presentation layer...

  ...however, check out the FORMAT function.  https://docs.microsoft.com/en-us/sql/t-sql/functions/format-transact-sql?view=sql-server-2017

  Thomas Rushton
  blog: https://thelonedba.wordpress.com

• jeffshelix

  SSCrazy

  Points: 2257

  More actions

  May 10, 2018 at 8:14 am

  #1990050

  Thanks, I concur with that . . . i lost sight of the big picture . . . .