SQL Server Rounding a number to 2 decimal places in SQL SERVER admin February 16, 2013 0 Use T-SQL Convert Function. Select convert ( decimal(8,2) , 9.4125 ) Output: 9.41 Get Free Email Updates! Signup now and receive free offers, discounts & coupon codes Thank you for subscribing. Something went wrong. I agree to have my personal information transfered to Mad Mimi ( more information ) I will never give away, trade or sell your email address. You can unsubscribe at any time. Related Related posts: No related posts. Post Navigation Previous Formatting DateTime to Date in SQL SERVERNext Custom 404 Error Page More Stories Other SQL Server Replace SQL Server new line with HTML admin September 9, 2021 0 SQL Server Formatting DateTime to Date in SQL SERVER admin February 16, 2013 0 SQL Server Finding duplicates with SQL? admin February 15, 2013 0 Leave a Reply Cancel replyYour email address will not be published. Required fields are marked *Comment * Name * Email * Website Save my name, email, and website in this browser for the next time I comment. Notify me of follow-up comments by email. Notify me of new posts by email. Δ This site uses Akismet to reduce spam. Learn how your comment data is processed.