Help to isolate records causing error on Cast VARCHAR TO INT

The process exports 8,576,460 out of 34,942,139 and generates this error: SQL3015N An SQL error "-420" occurred during processing. How do I isolate the record causing this issue? ## Deliverables Please don't bid on this project unless you understand the issue and can provide the solution. This is the SELECT CAST(REG.pnr_reg_key_checkno AS INT) AS CHECK_EFT_NUMBER,--cast(CASE WHEN REG.PNR_REG_KEY_CODE = 'DD' THEN CLEAN_ACCOUNT(PNR.BNK_NO) END as int ) AS EFT_ROUTING_NUMBER From PNR_REG_INTERIM SQL3015N An SQL error "-420" occurred during processing. Possible solutions: Function, proc or select statement to return the row(s) causing this error Pseudo code Read each row to isolate the error Write the record causing the issue to the CONV_DATA_SCRUBBER table Continue **How it could work:** Input data type: VARCHAR Output data type: INT Function found a non-numeric data in the PNR_REG_KEY_CHECKNOWrote the RECORD_ID, PNR_REG_KEY_CHECKNO to the CONV_DATA_SCRUBBER table If you have any other suggestions, please feel free to provide.