Round decimal to the nearest whole number


  • I have a table that contains whole and decimal numbers. I would like to round decimals to their whole #s.

    Example: 21.4 should result to 21.    21.5 to 22     22. 9 to 22        21.1 to 21 etc.


    I am using sql express 2005 and web developer 2008 express.

    Also, if it possible write me the VB code, please.



    Sunday, September 14, 2008 10:37 PM

All replies