Path: newssvr20.news.prodigy.com!newsmst01a.news.prodigy.com!prodigy.com!news.moat.net!border1.nntp.sjc.giganews.com!border2.nntp.sjc.giganews.com!nntp.giganews.com!news1.optus.net.au!optus!newsfeeder.syd.optusnet.com.au!news.optusnet.com.au!not-for-mail
Newsgroups: comp.databases.oracle.server
Subject: Re: can wild cards be used in BETWEEN clause
References: <c5eabd$l053@kcweb01.netnews.att.com> <om5m70h89ft08j330qm71bbm9qbirjslqs@4ax.com> <opr6c9mny03d8uqx@news.optusnet.com.au> <1JGec.25788$rg5.42057@attbi_s52>
Message-ID: <opr6de8ny03d8uqx@news.optusnet.com.au>
From: "Howard J. Rogers" <hjr@dizwell.com>
Organization: Dizwell Informatics
Content-Type: text/plain; format=flowed; charset=iso-8859-15
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Date: Tue, 13 Apr 2004 11:18:13 +1000
User-Agent: Opera7.23/Win32 M2 build 3227
Lines: 40
NNTP-Posting-Host: 203.164.6.13
X-Trace: 1081819098  20347 203.164.6.13
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:259412

On Tue, 13 Apr 2004 00:43:42 GMT, VC <boston103@hotmail.com> wrote:

> Hello Roger,

I appear to get this all the time. The name is HOWARD, not roger.

"Rogers", with an 's', is my surname.

> You are quite right about BETWEEN accepting 'wildcards'.  However,  the
> following statement is incorrect:
>
> <quote>
> It seems to me perfectly logical. Show me everything between A and B
> should not show me B itself, because I've asked for things *between* two
> points, but not the points themselves.
> </quote>

The dangers of trying to simplify a message.

The point I should have made is that if you ask for things between 'A' and 
'B', you want things starting at A-nothing-nothing-nothing..., which stop 
at (and yes, include) B-nothing-nothing-nothing.... But 'BELGIUM' is 
greater than 'B' on its own, and therefore isn't between the two points. 
So it doesn't get included.

So yes, I agree with you. I phrased it very badly, and picked an extremely 
silly example to illustrate the point.

Now, could you (and everyone else who makes the same mistake) try and get 
my name right?

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