{"id":173,"date":"2012-04-24T09:17:52","date_gmt":"2012-04-24T09:17:52","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2012\/04\/24\/convert-varchar-to-int-sql-server\/"},"modified":"2012-04-24T09:17:52","modified_gmt":"2012-04-24T09:17:52","slug":"convert-varchar-to-int-sql-server","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2012\/04\/24\/convert-varchar-to-int-sql-server\/","title":{"rendered":"Convert VARCHAR to INT SQL Server"},"content":{"rendered":"
Conversion from varchar to int (integer) can be done using CAST or CONVERT.<\/p>\n
Below peice of code converts varchar to int using CAST.<\/p>\n
[sql]
\nDECLARE @intVariable INT
\nDECLARE @VarcharVariable VARCHAR(10)<\/p>\n
SET @VarcharVariable = ‘99999’<\/p>\n
–Converting VARCHAR TO INT Using CAST
\nSET @intVariable = CAST(@VarcharVariable as int)<\/p>\n
SELECT @intVariable , @VarcharVariable
\n[\/sql]<\/p>\n
Below peice of code converts varchar to int using CONVERT.
\n[sql]
\nDECLARE @intVariable INT
\nDECLARE @VarcharVariable VARCHAR(10)<\/p>\n
SET @VarcharVariable = ‘999999’<\/p>\n
–Converting VARCHAR TO INT Using Convert
\nSET @intVariable = CONVERT(int,@VarcharVariable)<\/p>\n
SELECT @intVariable , @VarcharVariable
\n[\/sql]<\/p>\n