Exactly 2 digits after decimal without Rounding

• ashishnaik1

  SSC Veteran

  Points: 252

  More actions

  September 28, 2007 at 9:27 am

  #181524

  Comments posted to this topic are about the item Exactly 2 digits after decimal without Rounding

• madhav.bms

  SSC Journeyman

  Points: 99

  More actions

  September 22, 2009 at 9:26 am

  #1056887

  We can also use the below conversion to get the same result.

  e.g to get only two digits after decimal for a value 6.0834298900

  Select LTRIM(RTRIM(STR(6.0834298900,10,2)))

  results in 6.08

  Cheers,

  Madhava.B