The best way to explicitly convert from one data type to another in SQL Server is with CAST(). So, assuming the data fit inside an int, CAST(column-name AS INT). If you are not sure if it will fit, TRY_CAST() might be what you are looking for.