Logic needed - kindly help!

Question

Hi,
whats the function or code in tsql for

If a number is => 0.5 then it should be converted to the next number
< 0.5 then it should be the same number

Eg:
0.01 should become 0
80.5 should become 81
800.01 should become 800

Answer 1

Hi @SELVAKUMAR VELU ,

Welcome to Microsoft Q&A!

Please also refer below:

DECLARE @Amount1 MONEY  
SET @Amount1 = 0.01  
DECLARE @Amount2 MONEY  
SET @Amount2 = 80.5  
DECLARE @Amount3 MONEY  
SET @Amount3 = 800.01  
SELECT CAST(@Amount1 AS INT)  
SELECT CAST(@Amount2 AS INT)  
SELECT CAST(@Amount3 AS INT)  

Output:

Best regards,
Melissa

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

I guess you mean the ROUND function?

;with testData as  
    (select 0.01 as val  
     union all select 80.5  
     union all select 800.01)  
select *, round(val, 0)  
from testData