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: