If you want to know which row is not implicitly not casting to varchar(5) you could open a cursor on the source table and add a try catch. In the catch insert the violating row into another table or output to a log table enough info to identify the offending row.