Get only two decimal points in a money data type in SQL Server

Question

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

But I need 123.46 .

The field data type is money.

Decision:

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

Answer 1

If applicable, format at the presentation level, and not on the data layer, that is, read all the data and wipe it later (for example, on a C # client)

Answer 2

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

Will do what you after

Answer 3

 SELECT ROUND(123.4567, 2,1) 

See http://msdn.microsoft.com/en-us/library/ms175003(SQL.90).aspx

Answer 4

 SELECT FORMAT(123.4567,'N2') 

It will help you get out

Answer 5

@IsmailS - for me, a larger image is the maximum possible format of a data server format, especially when it is something as simple as an embedded listing. This gives less clutter in your other code. For example, casting price , money field:

select CAST(Price as numeric(17,2)) Price from PriceTable

YMMV - This is my personal experience.