Home Forums SQL Server 2014 Development - SQL Server 2014 How to remove trailing zeros from a decimal (type) value? RE: How to remove trailing zeros from a decimal (type) value?

  • March 16, 2014 at 9:32 pm

    #1697540

    Normally you should not care about trailing 0's. The front end worries about the display and making it pretty.

    But if you have to, this should do it:

    Select cast(100/2.0 as decimal(3))

    __________________________________________________________________________________________________________
    How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/