title: Round to .5 or 1.0 in SQL
body: <p>I'm looking to round values like</p>
  <blockquote>
  <p>2.3913 -&gt; 2.5</p>
  <p>4.6667 -&gt; 4.5</p>
  <p>2.11 -&gt; 2</p>
  </blockquote>
  <p>How can I manage this in SQL?</p>
  <p>Thanks</p>