• So... in the following code

    declare @result decimal(12,8);

    set @result = round (5/3.0, 4,3);

    select @result;

    I get 1.66660000

    The operation (5/3.0) completes and the rounding is done according to the variable declared

    (decimal(12,8) - 1.66666667 - and then truncated to 4 places - 1.6666?

    Sorry to be a pain, but how is it that I get 1.66660000 instead of 1.66670000? Which step decides if I get the 7 or 6 at the end?:unsure: