Update the numeric in Decimal

Question

Hello, I have to replace the number in decimal area with Zero if decimal value is less than 0.99

Data:
7889.00008000
7828.00800000
7363.00000060
7363.99999990

Expected output: --All decimals should be Zero except if decimal value is less than 0.99
7889.00000000
7828.00000000
7363.00000000
7363.99999990

Answer 1

Declare @Sample Table(Nbr decimal(15,8));  
Insert @Sample(Nbr) Values  
(7889.00008000),  
(7828.00800000),  
(7363.00000060),  
(7363.99999990);  
  
Update @Sample  
Set Nbr = Floor(Nbr)  
Where Floor((Nbr*100)) % 100 <> 99;  
  
Select Nbr From @Sample;  

Tom

Answer 2

Did you try to CAST the numeric to decimal?

DECLARE @n numeric = 7363.00000060;
SELECT CAST(@n AS decimal(20, 8));