Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: domain of rjcarr@gmail.com designates
 209.85.146.178 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=N+8Up7a4ubNPcoubkelubN17FPS3HOZCVPEAnat829Fi/ojU3Uym0xFBnjnlUz/P7dMo/OPQu1AmVkfbZ8i+OJWxhodl+APR6V0yo87U6Km+iH6pUUqbKNi5VVBPrvfj8R+cblmpjLGC7QmUg69cO5FQIAkPkL8efg/GeoiLD4M=
Message-ID: <d46327c70805282127y2a79c438id2e585e6bcbb8d11@mail.gmail.com>
Date: Wed, 28 May 2008 21:27:54 -0700
From: "Robert J. Carr" <rjcarr@gmail.com>
To: "Derby Discussion" <derby-user@db.apache.org>
Subject: Re: Select Alpha Rows
In-Reply-To: <MTAwMDAxNy54cjR0aQ.1212034757@quikprotect>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <MTAwMDAxNy54cjR0aQ.1212034757@quikprotect>

Just a guess ( assuming [A,C) ):

select * from table where (name >= 'A' and name < 'C') or (name >= 'D'
and name < 'G')

On Wed, May 28, 2008 at 9:20 PM, Kai Ponte <kai@perfectreign.com> wrote:
> I have a table, which is a list of names and other information about people
>
> I want to select only those names that - say - are between A and C, then
> select D through G, and so on.
>
> I can't seem to figure out how to do this.
>
> Do I need to setup a View that sorts all names and select between them?
>
>
> --
> kai
> www.filesite.org || www.4thedadz.com || www.perfectreign.com
> remember - a turn signal is a statement, not a request
>