How to round without trailing zeros in SQL Server 2005?

Question

How to round without trailing zeros in SQL Server 2005?

select round(100.5555, 2) 

... gives 100.55 00 . How to get rid of zeros?

Answer 1

try it

 select CAST(round(100.5555, 2) AS DECIMAL(8,2)) 

Answer 2

You can reuse it as a source data type, for example

 SELECT CAST(ROUND(100.5555, 2) AS FLOAT) 

However, this sounds like display logic, and therefore I suspect that you are better off doing this in your user interface, rather than in your database.

Answer 3

declare @d decimal (8.2) can help you.