Trouble converting a column of digits from string to integer .

GavSol  I would advise TRY_CAST ex

TRY_CAST(COLUMN  AS VARCHAR(MAX))

It will NULL values it can't convert

---

Does anyone have any ideas. 

---

GavSol , idea on what?

You didn't provide any usefull information, exactly close to no information.

Which SQL Server version are you using? What do you want to convert where? How does the source data look like? If you get errors, which one?

Olaf