Last post Jan 03, 2017 06:41 AM by Eric Du
Jan 01, 2017 08:27 AM|Capricon User|LINK
Jan 01, 2017 06:37 PM|Capricon User|LINK
Jan 03, 2017 06:41 AM|Eric Du|LINK
Hi Bakhtawar Ashiq,
Conversion failed when converting the varchar value '233,344,455' to data type int
According to this error message, as far as I know, you could try to use replace method to convert '233,344,455'
to INT type, it can replace ',' to blank, then convert it to int type.
SELECT CAST(REPLACE('233,344,455',',','') as int)