Converting a number to a decimal also performs rounding, so I would suggest this....
Code:
Select Convert(Decimal(10,2), 1.1234567)
The decimal data type allows for precision and scale. The precision (in this example = 10) means.... allow 10 total digits. Scale (in this example = 2) means... allow 2 digits after the decimal.
So, Decimal(5,2) has a range of -999.99 to 999.99
Make sense?
-George
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.