You're dividing an integer by an integer, which will return an integer (no decimal places), then the conversion to decimal takes place. Try:-
select cast (3/2.0 as decimal (5,2)) as 'test'
and you get 1.5
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx