Home Forums SQL Server 2005 T-SQL (SS2K5) Remove Decimals Without Rounding RE: Remove Decimals Without Rounding

  • September 29, 2007 at 2:37 pm

    #737413

    This should do the trick... 100% of the time :

    DECLARE @val DECIMAL (11,8)

    SET @val = 100.10300100

    SELECT REPLACE(RTRIM(LTRIM(REPLACE(REPLACE(CONVERT(VARCHAR(30), @val), '.', ''), '0', ' '))), ' ', '0')

    SET @val = 0.01

    SELECT REPLACE(RTRIM(LTRIM(REPLACE(REPLACE(CONVERT(VARCHAR(30), @val), '.', ''), '0', ' '))), ' ', '0')

    SET @val = 1

    SELECT REPLACE(RTRIM(LTRIM(REPLACE(REPLACE(CONVERT(VARCHAR(30), @val), '.', ''), '0', ' '))), ' ', '0')

    SET @val = 0010.20301

    SELECT REPLACE(RTRIM(LTRIM(REPLACE(REPLACE(CONVERT(VARCHAR(30), @val), '.', ''), '0', ' '))), ' ', '0')