It can be surprising to see certain results when doing numeric arithmetic: declare @num1 numeric(38,10) declare @num2 numeric(38,10) set @num1 = .0000006 set @num2 = 1.0 select cast( @num1 * @num2 as numeric(38,10)) Yields: .0000010000 Instead of: .0000006000
