Decimal Scale!

8 Jul 2005 4:52 AM

Arpan

DECLARE @mymoney money
SET @mymoney=5148.72846
SELECT CAST(@mymoney AS decimal(10,3)) AS "Decimal Money"

The result of the above code is 5,148.73 but shouldn't the output be
5,148.729 since the scale has been set to 3?

Thanks,

Arpan

8 Jul 2005 6:34 AM

Uri Dimant

Hi
Its ok, I got 5148.729
What vesrion of SQL Server are you using? Have you applied SP3/4?

Show quote

"Arpan" <arpan***@hotmail.com> wrote in message
news:1120798361.315824.190510@f14g2000cwb.googlegroups.com...
> DECLARE @mymoney money
> SET @mymoney=5148.72846
> SELECT CAST(@mymoney AS decimal(10,3)) AS "Decimal Money"
>
> The result of the above code is 5,148.73 but shouldn't the output be
> 5,148.729 since the scale has been set to 3?
>
> Thanks,
>
> Arpan
>