On Tue, Dec 4, 2018 at 1:38 PM Joshua D. Drake <j...@commandprompt.com> wrote: > I may be misunderstanding the question but: Indeed... > select cast(x/y as numeric(10,4));
Your answer is 2.0 instead of the correct 2.5 - you need to cast before the division, not after. David J.