sql - 使用sql查询将字符串转换为int(Convert a string to int using sql query)

Question

如何在SQL Server 2005上使用SQL查询将字符串转换为整数？

  ask by Rahul Vyas translate from so

Answer 1

You could use CAST or CONVERT :

(您可以使用CAST或CONVERT ：)

SELECT CAST(MyVarcharCol AS INT) FROM Table

SELECT CONVERT(INT, MyVarcharCol) FROM Table