• SELECT CONVERT(INT,ROUND(<YourColumnName>,0)) FROM <yourtable>