Received: from desmpop1.desm.uswest.net (desmpop1.desm.uswest.net [207.108.32.1]) by hub.org (8.9.1/8.9.1) with SMTP id NAA06229 for ; Sat, 9 Jan 1999 13:10:04 -0500 (EST) (envelope-from tim@dmcity.net) Received: (qmail 911 invoked by alias); 9 Jan 1999 18:10:00 -0000 Delivered-To: fixup-pgsql-sql@hub.org@fixme Received: (qmail 904 invoked by uid 0); 9 Jan 1999 18:10:00 -0000 Received: from bdsl97.desm.uswest.net (HELO timnt) (207.108.36.97) by desmpop1.desm.uswest.net with SMTP; 9 Jan 1999 18:10:00 -0000 Message-ID: <003b01be3bfa$61815040$61246ccf@timnt.desm.uswest.net> Reply-To: "Tim Perdue, The Des Moines City.net" From: "Tim Perdue, The Des Moines City.net" To: Subject: SELECT... BETWEEN 'P' and 'Z' Date: Sat, 9 Jan 1999 12:03:37 -0600 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Hello all, I am trying to query a zip code database and pull all cities in a state in a range. According to the SQL tutorial that the pgsql site recommended, using "between" in your select should be "inclusive". However, my selects are including the first letter "p" through "y", and excluding "z". My SQL: select distinct on fld_city fld_city, fld_zip from tbl_zip_city where fld_state = 'IA' and fld_country='us' and (fld_city BETWEEN 'P' AND 'Z') ORDER BY fld_city ASC; Any suggestions on how I could get the cities that start with "Z" to be included here (P is included strangely enough)? Thanks, Tim Perdue