• Ray is right. You would be getting 44.9 rather than 44.8

    Start with this.

    select ROUND(44.8730084,1) -- gives 44.9000000 as output

    Or try this way.

    declare @val float;

    set @val = 44.8730084

    select ROUND(@val,1,1) -- gives 44.8 as output

    select ROUND(@val,1,0) -- gives 44.9 as output


    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty