Please have at look at BOL (BooksOnLine), section "ROUND function", sub section "C. Using ROUND to truncate".
Just out of curiosity:
Is it a coincidence having almost the identical question on this post http://www.sqlservercentral.com/Forums/FindPost738765.aspx or is it you just with a different nickname?
Lutz
A pessimist is an optimist with experience. How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]