I'm attempting to identify invalid characters stored in a varchar2 column.

Despite it's format, it represents the invoice number in Oracle Receivables.

Unfortunately, I am trying to do a comparison between the 'number' stored and a range of numbers. Because there are a few rows with other ascii characters stored, I'm getting an ora-01722: invalid number returned.

Does anyone have a script which can check for those records with an invalid value?