Get only two decimal points in money datatype in SQL Server

Question

SELECT ROUND(123.4567, 2)` gives me `123.4600`

But I need 123.46.

Data type of field is money.

Solution:

<%# DataBinder.Eval(Container.DataItem, "FieldName","{0:0.00}") %>

Answer 1

SELECT CAST(ROUND(123.4567, 2) AS MONEY)

Will do what you are after

Answer 2

If applicable, format on the view layer, not on the data layer, i.e. read all the data and truncate it later (such as in C# client)