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 <[EMAIL PROTECTED]> 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 >
