SQL: Convert Varchar to Int
Posted on 2008-10-31
I am trying to use CAST to convert a Varchar to an Integer
set field1 = (select CAST(field2 as INT) from table2 where......
The values in field 2 are all numeric with 2 decimals. The error reads: " Syntax error converting the varchar value of '1,456.88' to a column of data type int.
based on other posts, I am assuming it is the comma it dosent like. But I am guessing, and not sure how to go about removing it in the process.