ROUND Function 1

[Digga]

Hi

Can someone tell me how to round a decimal datatype value up to the nearest .5 in MS SQL.

For example:

1.2 = 1.5
1.4 = 1.5
1.6 = 2.0
1.8 = 2.0

etc., etc.

Many thanks in advance.

Digga

Sharing Knowledge Saves Valuable Time!

 

[Jamfool]

declare @a decimal(10,2)
select @a = 1.34

SELECT ROUND(@a/.5,0) *.5

--or for two places

SELECT ROUND(@a/.5,1) *.5

--Note 1.2 will be rounded down

 

[tlbroadbent]

Try this: SELECT Round(1.8*2.0 + 0.5, 0) / 2.0

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.comcast.net/sql/sql_articles.htm

 

[Digga]

Hi Guys

Thanks for your responses.

Jamfool, thank you, I had tried this and it didn't meet my needs as I wanted to round up, but thanks anyway.

Terry, spot on mate, thank you very much.

Digga

Sharing Knowledge Saves Valuable Time!