Description: Sql server function to round up/down to nearest dollar, nearest 5/10 dollar,Įlse can test it by following sql scripts Here is a small function that you can add in your database to achieve this result. This can be done at either the coding end or at the Database end itself.
For example, you might need to display 1.44 as 1.45 and 1.89 as 1.90.
In an application you need to round up numbers to nearest 5 or nearest 10 all the time.
