Round money values to only 2 decimals

Transact-SQL
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

1 Like
3

Perfect, thanks a lot kazeem.

Luigi