Home Forums SQL Server 2005 T-SQL (SS2K5) How to trim the decimal places? RE: How to trim the decimal places?
Ramesh Saive
SSC-Insane
Points: 24275
More actions
May 20, 2009 at 5:49 am
#997515
Using ROUND function...
SELECT CONVERT( NUMERIC(18,2), ROUND(1245.65879, 2, 1) )
--Ramesh