On Mon, 12 Apr 2004 23:27:42 +0100, Andy Hassall <andy@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-
===========================================