Mega Code Archive

 

Categories / MSSQL Tutorial / Math Functions

 

Rounding present value to two decimal places

4> 5> 6> SELECT ROUND(1464*(1/POWER((1+.10),4)),2) 7> GO ----------------------------------------      1002.740000000000000000000000000000 (1 rows affected) 1>