title: Round up to 5 cents
body: <p>I have got the next query.</p>
  
  <pre><code>ALTER FUNCTION [dbo].[Test] (@i DECIMAL(10, 2))
  RETURNS DECIMAL(10, 2)
  AS
  BEGIN
      DECLARE @j DECIMAL(10, 2)
  
      SET @j = @i - floor(@i)
  
      RETURN CASE 
              WHEN @j &lt; 0.25
                  THEN floor(@i)
              WHEN @j &lt; 0.75
                  THEN floor(@i) + 0.5
              ELSE ceiling(@i)
              END
  END
  
  return case when @j&lt;0.25 then floor(@i) when @j&lt;0.75 then floor(@i)+0.5 else ceiling(@i) end
  
  END
  </code></pre>
  
  <p>This is for round with 0.5, but how can I change this to always round up with 0.05, unless it's already at an round of 0.05?</p>