Rounding in Sql Server 2008 -

i want round decimal values in sql server if value 1.1 result should 2(next value). how in sql server , inbuilt method there or want manually?

edit:

if value der in decimal place result should next integer value

please help

don't mean post simplistic answer, have looked @ ceiling / floor?

select ceiling(1.1);  ---- 2 

from msdn, ceiling "returns smallest integer greater than, or equal to, specified numeric expression."