SQL, round to the nearest whole number

Please try this

/*------------------------
SELECT CEILING(.03) 
UNION ALL
SELECT CEILING(1.03) 
------------------------*/

---------------------------------------
1
2

(2 row(s) affected)

Select allOpen in new window

Another solution for you.

/*------------------------

SELECT CASE WHEN CAST(a AS FLOAT) LIKE '%.%' THEN CAST(1 + a AS INT) ELSE a END 
FROM
(
	SELECT (.03) a
	UNION ALL
	SELECT (1.03) 
	UNION ALL
	SELECT 2 
	UNION ALL
	SELECT 5 
)r
------------------------*/

---------------------------------------
1.00
2.00
2.00
5.00

(4 row(s) affected)

Select allOpen in new window

Actually strictly speaking 1.03 rounded to the nearest whole number is 1 not 2. For this one usually uses bankers rounding
int (value + .45)

@Author - did u tried my suggestions, both are giving exactly same output you need. Thanks

Thanks
I wasn't sure what ceiling does.
it works fine
have a nice day!