How do I round a number to five?

[lwilly]

Could someone give me an idea of how I can round numbers to the nearest five in a select statement?
Thank you,
Any help would be appreciated.

 

[vongrunt]

Try round( myfield/5, 0 ) * 5

 

[skuhlman]

declare @x numeric(10,2)
set @x=7.5
select round(@x/5,0)*5

 

[lwilly]

Thank you both for the quick replies, I have been scratching around trying to get this and all along it was because my field was an int so it was always rounding down.
Thanks again!