title: Incrementing decimal up to certain decimal then using next whole number in SQL
body: <p>I have a requirement to transform a decimal value and add .1 to it. My problem is that if this value would become a '.5' value, it instead needs to round up to the next whole number.</p>
  
  <p>For example: If I have a value of '3.1' this would become '3.2'
  If I have a value of '5.3' this would become '5.4'
  If I have a value of '6.4' this would become '7.0'</p>
  
  <p>I currently do this using a case statement so if the '.X' part is 4 it adds 0.6 else it adds 1, but is there a more efficient/better way of doing this?</p>
  
  <p>Example of current code:</p>
  
  <pre><code>declare @Example Decimal (5,1) = '4.4'
  
  select case when @Example like '%.4' then (@Example + '0.6')
  else @Example + '0.1' end
  </code></pre>
  
  <p>Thanks!</p>