RE: to_number question

From: <Stephen.Lee_at_DTAG.Com>
Date: Wed, 14 Jul 2004 21:00:00 -0500
Message-ID: <D6339830FC73944E889CC3CEADDB205B07909519@bu-dtagpo1.tracs.com>

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed Jul 14 2004 - 20:56:45 CDT