You just have to cast the right numbers:
declare int int
declare div int

set int = 10
set div = 3

select cast(int/cast(div as decimal(5,2)) as decimal(5,2))

"Guy Brown" <brownguy_rhotmail.com> a écrit dans le message de news: 027d01c34185$2701efc0$a101280aphx.gbl...
> I am new at this so if it is a dumb question please give
> me a break.
>
> I am dividing to columns that are integers, trying to get
> the decimal places on the division. The results come back
> as whole numbers. I tried to cast the results into a
> decimal format, but am still getting a whole number
> result. Any help would be greatly appreciated.
>
>