RE: SQL query

From: Thomas Biju <BThomas_at_br-inc.com>
Date: Mon, 28 Jun 2004 11:12:39 -0500
Message-ID: <75DFF91B31A1284992092BDB70C923240584171B@ftwp45ns.br-inc.net>

If column contains digits,

select ...
WHERE mycol between 100 and 999999999;

If characters:

select ...
WHERE length(mycol) between 3 and 9;

-----Original Message-----

From: Nguyen, David M [mailto:david.m.nguyen_at_xo.com] Sent: Monday, June 28, 2004 11:08 AM
To: oracle-l_at_freelists.org
Subject: SQL query

How do I query a column that has only a minimum of 3 digits and a maximum of 9 digits?
=20

Thanks,

David

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

___________________________________________________________________________=
__________________________________

This electronic transmission and any attached files are intended solely for=
 the person or entity to which they are addressed and may contain informati=
on that is privileged, confidential or otherwise protected from disclosure.=
 Any review, retransmission, dissemination or other use, including taking a=
ny action concerning this information by anyone other than the named recipi=

ent, is strictly prohibited. If you are not the intended recipient or have = received this communication in error, please immediately notify the sender = and destroy this communication.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Mon Jun 28 2004 - 11:11:51 CDT