Search the Community
Showing results for tags 'round'.
A while back I was trying to round some numbers to only 2 digits after the decimal in MSSQL. I figured out how to do and wanted to share. Name of Table: Invoice Field Name: BalanceDue Data Set: 100.0001 34.532 49.4732 234.567000 Expected Data Set: 100.00 34.53 49.47 234.57 To do this you can use the ROUND function within MSSQL. select round(BalanceDue,2) from Invoice