How to convert a string to integer using SQL query on SQL Server 2005?
See Question&Answers more detail:osHow to convert a string to integer using SQL query on SQL Server 2005?
See Question&Answers more detail:osYou could use CAST or CONVERT:
SELECT CAST(MyVarcharCol AS INT) FROM Table
SELECT CONVERT(INT, MyVarcharCol) FROM Table