Home Forums SQL Server 2012 SQL Server 2012 - T-SQL How to Trim Values if more than 2 numbers after '.'? RE: How to Trim Values if more than 2 numbers after '.'?

  • July 23, 2015 at 11:34 am

    #1814478

    Thank you for the feedback. I had to alter what you posted slightly to get it to work. See below:

    UPDATE AnnualClassifiedPAFs

    SET [Hrs Total 1] = (ROUND ([Hrs Total 1],2))