OK. It's something about the WHERE clause being outside the subquery. (Mebbe somebody can explain it.) select nbr_cc_fop_name from nbr_cc where nbr_cc_fop_name in ('AX','MC','VI','DS') and to_number(trim(nbr_cc_no_high)) - to_number(trim(nbr_cc_no_low)) > 0 WORKS! ---------------------------------------------------------------- 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 -----------------------------------------------------------------