mssql Rounding Numbers

[Nathan]

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