Round column numbers to nearest dollar in Sql Server 2005

In T-SQL, Round(123.20, 0) = 123.

This SQL guide is the only reference book that is on my desk. Whenever I have an SQL question, I look there first.

How would I structure that query?

The table is: tblPlumbingListBidDetail

The column name is: UnitPrice

I basically only work with the application that is attached to the database....

Like this:

SELECT ROUND(UnitPrice, 0)
   FROM tblPlumbingListBidDetail

Select allOpen in new window

It didn't work - probably because I have NULL values in the column?

You can use ISNULL or COALESCE to provide zero instead of null, like this:

SELECT ROUND(ISNULL(UnitPrice,0), 0), Field1, Field2, Field3
   FROM tblPlumbingListBidDetail

SELECT COALESCE(ISNULL(UnitPrice,0), 0), Field1, Field2, Field3
   FROM tblPlumbingListBidDetail

Select allOpen in new window

Thanks!