Home Forums Article Discussions Article Discussions by Author Discuss content posted by ashishnaik1 Exactly 2 digits after decimal without Rounding RE: Exactly 2 digits after decimal without Rounding

  • 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