X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 785179FB321 for ; Thu, 10 Aug 2006 18:32:13 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 70196-08 for ; Thu, 10 Aug 2006 18:32:08 -0300 (ADT) X-Greylist: delayed 00:59:59.197627 by SQLgrey- Received: from mmp3.nems.noaa.gov (mmp3.nems.noaa.gov [140.90.121.158]) by postgresql.org (Postfix) with ESMTP id D5A479FB2F8 for ; Thu, 10 Aug 2006 18:32:07 -0300 (ADT) Received: from [204.227.103.140] (pc5.krf.noaa.gov [204.227.103.140]) by mmp3.nems.noaa.gov (iPlanet Messaging Server 5.2 HotFix 2.01 (built Aug 26 2004)) with ESMTPSA id <0J3S008KXUDE2W@mmp3.nems.noaa.gov> for pgsql-sql@postgresql.org; Thu, 10 Aug 2006 16:32:03 -0400 (EDT) Date: Thu, 10 Aug 2006 15:32:05 -0500 From: Juliann Meyer Subject: how do I check for lower case To: pgsql-sql@postgresql.org Message-id: <44DB97C5.9090307@noaa.gov> Organization: Missouri Basin River Forecast Center MIME-version: 1.0 Content-type: multipart/mixed; boundary="Boundary_(ID_vx7GCHOxEdx9jPmOqmh2jw)" User-Agent: Thunderbird 1.5.0.5 (Windows/20060719) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200608/72 X-Sequence-Number: 26030 This is a multi-part message in MIME format. --Boundary_(ID_vx7GCHOxEdx9jPmOqmh2jw) Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7BIT I have a table with a column, lets call it identifier, that is defined as varchar(8) that should never contain lower case letters. Its a large table. Is there a way to query the table to see if any values in this column are lower case and to get a list out? The user interface application that users use prevents them from adding an entry in lower case now, but didn't in earlier version. Julie --Boundary_(ID_vx7GCHOxEdx9jPmOqmh2jw) Content-type: text/x-vcard; charset=utf-8; name=julie.meyer.vcf Content-transfer-encoding: 7BIT Content-disposition: attachment; filename=julie.meyer.vcf begin:vcard fn:A. Juliann Meyer org:National Weather Service;Missouri Basin River Forecast Center adr;dom:;;;Pleasant Hill;MO;64080 email;internet:julie.meyer@noaa.gov title:Sr. Hydrologist - Data Systems x-mozilla-html:FALSE version:2.1 end:vcard --Boundary_(ID_vx7GCHOxEdx9jPmOqmh2jw)--