I’m importing a table which is supposed to have an integer primary key, but the data is messy and we find things like “6TEST3” or “CREDIT3” in this field. I want to read the table and use this field as an integer, however can’t convert it because of those rows.
Is there a way to remove a row if I can’t convert a field value to integer?
Best answer by rogier.helmus
View original