>I am doing an insert from a table into another. However, in the new table, a field is numeric and in the other table it is character. The initial table should have only numeric values in the field. However, because it is character and because there was a problem once in a specific set of records, I can see there are character values in that field. Is there a way, when doing the insert command to specify to convert the character value into a numeric value so to avoid the error when trying to import those records when it reaches them?

You can add

WHERE ISNUMERIC(MyColumn) = 1