> -----Original Message----- > Almost certainly somewhere in your column you have at least > one value that fails to convert to a number. I'm inclined to agree because the following works: to_number(translate(nbr_cc_no_high,'0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcd efghijklmnopqrstuvwxyz ','0123456789')) Some creator of data around here needs to be slapped. You still have to wonder why it isn't a problem in the SELECT part; but IS a problem in WHERE part. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------