convert a string to int using sql query

Question

i want to convert a string field to integer using sql query?

Answer 1

You could use CAST or CONVERT:

SELECT CAST(MyVarcharCol AS INT) FROM Table

SELECT CONVERT(INT, MyVarcharCol) FROM Table