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