Hi,

Can you tell me which of the following division outcomes is expected behaviour?

--Division                 -- outcome

select

10/3,                         -- 3

10/3.0,                       -- 3.333

10.0/3,                       -- 3.333

cast(10 as decimal(18,2))/3,  -- 3.333

cast(10 as decimal(18,0))/3,  -- 3

cast(10 as decimal(18,0))/3.0 -- 3.333

;

Personally, I would have expected all of the outcomes to be real numbers and not integers.

Can you tell me if that is a realistic expectation?

Kind regards,

Frank Groot