Received: from bubba.NMSU.Edu (bubba.NMSU.Edu [128.123.3.39]) by hub.org (8.8.8/8.7.5) with ESMTP id QAA28279 for ; Mon, 13 Jul 1998 16:27:17 -0400 (EDT) Received: from dns1.NMSU.Edu (dns1.NMSU.Edu [128.123.3.5]) by bubba.NMSU.Edu (8.9.0/8.9.0) with ESMTP id OAA09840 for ; Mon, 13 Jul 1998 14:27:30 -0600 (MDT) Received: from wilma.NMSU.Edu (wilma.NMSU.Edu [128.123.3.12]) by dns1.NMSU.Edu (8.9.0/8.9.0) with ESMTP id OAA23593 for ; Mon, 13 Jul 1998 14:26:57 -0600 (MDT) Received: from localhost (lorenzo@localhost) by wilma.NMSU.Edu (8.9.0/8.9.0) with SMTP id OAA19680 for ; Mon, 13 Jul 1998 14:26:54 -0600 (MDT) X-Authentication-Warning: wilma.NMSU.Edu: lorenzo owned process doing -bs Date: Mon, 13 Jul 1998 14:26:53 -0600 (MDT) From: Lorenzo Huerta X-Sender: lorenzo@wilma To: pgsql-sql@postgreSQL.org Subject: case-insensitive lookups... Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII is there a way to do selects /etc on fields without regard to upper/lower case of the data in the fields? Thanks, __________________________________________________________________ * Lorenzo J. Huerta * * Programming Assistant * * Computing & Networking Networking Architecture and Operations * * New Mexico State University * * phone: (w)(505)646-2582 (h)(505) 521-8699 fax:(505) 646-8139 * * e-mail: lorenzo@nmsu.edu * * Web Site: http://web.nmsu.edu/~ljhuerta * __________________________________________________________________