Received: from mail.ldssingles.com (mail.ldssingles.org [63.226.117.101]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4TG3CE71421 for ; Tue, 29 May 2001 12:03:12 -0400 (EDT) (envelope-from mark@zserve.com) Received: from mark.ldssingles.com (mark.ldssingles.com [192.168.1.31]) by mail.ldssingles.com (8.11.2/8.11.2) with ESMTP id f4TG3BW08512 for ; Tue, 29 May 2001 10:03:11 -0600 Message-Id: <200105291603.f4TG3BW08512@mail.ldssingles.com> Subject: Case Insensitive Queries From: Mark To: pgsql-sql@postgresql.org Content-Type: text/plain X-Mailer: Evolution (0.9 - Preview Release) Date: 29 May 2001 09:11:23 -0600 Mime-Version: 1.0 X-Archive-Number: 200105/307 X-Sequence-Number: 3148 Is it possible to execute a query using a where clause that allows case insensitive comparison between a field and text. For example: select * from account where username = 'test' where username could be 'Test', which would be a match. As is, this compare is case sensitive. grep'd the source, but stricmp is only used for keywords and not actual column data. Any help would be greatly appreciated. Thanks, Mark