SQLTeam.com | Weblogs | Forums

Round money values to only 2 decimals


#1

Hello all,
in SQL Server 2008 I have a table with a money field that has some values with 3 or more decimals.

The web application needs values with only 2 decimal after comma.

How can I round all values of this field to obtain numbers with only 2 decimals?

Thanks a lot in advance.

Luigi


#2

Use Round function;

SELECT ROUND(MONEY_FIELD,2) FROM TABLE_NAME

2 is number of places after decimal


#3

Perfect, thanks a lot kazeem.

Luigi