On Tue, Dec 4, 2018 at 1:38 PM Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx> 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.
