Convert a string to int using sql query?

Question

How to convert a string to integer using SQL query on SQL Server 2005?

Answer 1

Use the cast() function e.g:

SELECT CAST('44' AS int);