db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Robert J. Carr" <rjc...@gmail.com>
Subject Re: Select Alpha Rows
Date Thu, 29 May 2008 04:27:54 GMT
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
>

Mime
View raw message