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

  • September 26, 2007 at 3:29 pm

    #736541

    declare @i decimal(10,2)

    Set @i = 1078.734

    select (left(@i, Charindex('.', @i, 1) - 1 ))

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************