Thank you. It helps. David -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Thomas Biju Sent: Monday, June 28, 2004 11:13 AM To: oracle-l@xxxxxxxxxxxxx Subject: RE: SQL query If column contains digits, select ... WHERE mycol between 100 and 999999999; If characters: select ... WHERE length(mycol) between 3 and 9; B. -----Original Message----- From: Nguyen, David M [mailto:david.m.nguyen@xxxxxx] Sent: Monday, June 28, 2004 11:08 AM To: oracle-l@xxxxxxxxxxxxx Subject: SQL query How do I query a column that has only a minimum of 3 digits and a maximum of 9 digits? =3D20 Thanks, David ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ________________________________________________________________________ ___=3D __________________________________ This electronic transmission and any attached files are intended solely for=3D the person or entity to which they are addressed and may contain informati=3D on that is privileged, confidential or otherwise protected from disclosure.=3D Any review, retransmission, dissemination or other use, including taking a=3D ny action concerning this information by anyone other than the named recipi=3D ent, is strictly prohibited. If you are not the intended recipient or have =3D received this communication in error, please immediately notify the sender =3D and destroy this communication. ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------