Home Forums SQL Server 2017 SQL Server 2017 - Development removed zeroes from numeric column RE: removed zeroes from numeric column

  • February 18, 2019 at 11:46 am

    #2022301

    Saurabh.D - Monday, February 18, 2019 11:25 AM

    I am curious to know, if there is any way to remove zeroes from numeric column without converting them into string.

    You could still use replace - REPLACE(Salary, 0, '') - without explicitly converting the values but the SQL statement will still do an implicit conversion

    Sue