Simple problem but irriatating me

[sandeep kumar pundhir]

hi can anyone please help me I have declare @Z decimal set @Z=0.1 select @Z the out put comes to be 0 WHY ? it shud be 0.1 Thanx

[Mike Dimmick]

You haven't specified the precision or scale parameters of the decimal type. Precision specifies the total number of decimal digits that can be stored, while scale specifies the number of digits to the right of the decimal point. The maximum number of digits to the left of the decimal point is then (precision - scale). If you don't specify these parameters, the default scale is 0 - so anything to the right of the decimal point is discarded and not stored. To store a number between -9.9 and 9.9, with one decimal place, you would say

declare @Z decimal**(2,1)**

-- modified at 6:08 Wednesday 23rd August, 2006 (forgot closing bold tag)

Stability. What an interesting concept. -- Chris Maunder