Re: can wild cards be used in BETWEEN clause

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Tue, 13 Apr 2004 09:17:01 +1000
Message-ID: <opr6c9mny03d8uqx@news.optusnet.com.au>

On Mon, 12 Apr 2004 23:27:42 +0100, Andy Hassall <andy_at_andyh.co.uk> wrote:

>
> BETWEEN doesn't accept wildcards,

So how come this works?

SQL> select * from countries where col1 between 'A%' and 'ZZ%';

COL1

---

ALGERIA
BOTSWANA
CHAD
DALMATIA
ENGLAND
WESTPHALIA
YUGOSLAVIA
ZANZIBAR And works, moreover, in 8.1.6, 9.2 and 10g.

Regards
HJR

-- 
-------------------------------------------
Dizwell Informatics: http://www.dizwell.com
  -A mine of useful Oracle information-
          -Windows Laptop Rac-
    -Oracle Installations on Linux-
===========================================

Received on Mon Apr 12 2004 - 18:17:01 CDT