Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
meanmyrlin
Starting Member
15 Posts |
 Posted - 2009-01-29 : 13:18:47
|
| Hello,Is it possible to round a number to the nearest 25? I am using price information so my numbers are decimals in the thousands. For example I would like 11,456.99 to round to 11,450 and 11,469.05 to round to 11475 and so on.Thanks,Natasha |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-01-29 : 13:49:56
|
| [code]select round(yournumber/25, 0)*25 as RoundedNo from yourtable[/code] |
 |
|
|
|
|
|
Rounding to a specific number