ansaurus

Question

Answer 1

+1 A:

declare @d decimal(8,2) can help you.

Saar 2009-11-04 13:17:42

Answer 2

+1 A:

Try this

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

astander 2009-11-04 13:22:41

What if I don't know the lenght 8, the only thing I know is that I need 2 digits arter dot?

Alex 2009-11-04 13:24:29

@astander: I got it, 8 is maximum, so I can just put any large enough number. Thanks!

Alex 2009-11-04 13:26:25

Answer 3

A:

You could re-cast it as your original datatype, e.g.

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

However, this sounds like display logic and therefore, I suspect you are better off doing this within your UI rather than your DB.

Robin Day 2009-11-04 13:22:47

How to round with no trailing zeros in SQL Server 2005?