Round to .5 or 1.0 in SQL

SELECT ROUND(2.2 * 2, 0) / 2 

gets you to the nearest .5

round(round(column/5,1)*5,1) closest 0.5
round(round(column/5,2)*5,2) closest 0.05