On Wednesday 28 May 2008 09:27:54 pm Robert J. Carr wrote: > Just a guess ( assuming [A,C) ): > > select * from table where (name >= 'A' and name < 'C') or (name >= 'D' > and name < 'G')
That's what I originally thought and tried. Seemed simple enough. :P I think I have the greaterthan and equal messed up. select FIRSTNAME, LASTNAME, TITLE, EMAIL from DBUSER.CONTACTS WHERE LASTNAME >= 'A' AND LASTNAME <= 'F' That seemed to work. <insert homer simpson remark here> Thanks!!! -- kai www.filesite.org || www.4thedadz.com || www.perfectreign.com remember - a turn signal is a statement, not a request
