Convert an expression to int: SELECTCONVERT(int,25.65); Try it Yourself » Definition and Usage The CONVERT() function converts a value (of any type) into a specified datatype. Tip:Also look at theCAST()funct