Received: from as.tksoft.com (gyw.com [209.55.67.177] (may be forged)) by hub.org (8.10.1/8.10.1) with ESMTP id e636wiS26813 for ; Mon, 3 Jul 2000 02:58:44 -0400 (EDT) Received: (from tjk@tksoft.com) by uno.tksoft.com (8.8.8/8.8.8) id XAA15921; Sun, 2 Jul 2000 23:58:39 -0700 From: "tjk@tksoft.com" Message-Id: <200007030658.XAA15921@uno.tksoft.com> Subject: Re: case insensitive search To: jomu@uni-paderborn.de Date: Sun, 2 Jul 2000 23:58:39 -0700 (PDT) Cc: pgsql-sql@postgresql.org In-Reply-To: <12843.000626@uni-paderborn.de> from "Joern Muehlencord" at Jun 26, 0 08:14:09 pm Content-Type: text X-Archive-Number: 200007/8 Joern, select myfield from tablea where lower(myfield) = 'mysearch'; or select myfield from tablea where myfield ~* 'mysearch'; Troy > > Hello together, > > how can I handle case insensitive search in a table? > > > > -- > Linux is like wigwam - no windows, no gates, apache inside. > In diesem Sinne > Joern > > >