This is how to convert a string to number to an SQL Server sentence.
SELECT CAST(YourVarcharCol AS INT) FROM Table
SELECT CAST(YourVarcharCol AS INT) FROM Table
examples
Convert to Integer
Select Cast(Customers.CodeId as Int) from Customers
Convert to a real
Select Cast(Customers.CodeId as float) from Customers
Convert to Integer
Select Cast(Customers.CodeId as Int) from Customers
Convert to a real
Select Cast(Customers.CodeId as float) from Customers