MathCeiling SQL Math Function

The MathCeiling() function takes one (1) argument and returns the smallest integral value that is greater than or equal to the specified decimal number., this kind of rounding is sometimes called rounding toward positive infinity. If number argument is negative, the rounding operation causes any fractional component of number to be discarded. If numbers are out of Double range which is set in .NET, it will return "Infinity".

Syntax MathCeiling( Number )

		/* Following will return 8 */ 

        SELECT MathCeiling(7.03);
		


		/* Following will return -7 */ 

        SELECT MathCeiling(-7.03);