Received: from master.netmaster.ca (root@netmaster.ca [204.244.213.44]) by hub.org (8.8.8/8.7.5) with ESMTP id NAA00143 for ; Tue, 26 May 1998 13:21:36 -0400 (EDT) Received: from netmaster.ca ([204.244.158.24]) by master.netmaster.ca with esmtp id m0yeNRE-000HbMC (Debian Smail-3.2 1996-Jul-4 #2); Tue, 26 May 1998 10:23:00 -0700 (PDT) Sender: root Message-ID: <356AFAD2.23A33F4D@netmaster.ca> Date: Tue, 26 May 1998 10:24:34 -0700 From: "Dana M. Epp" Organization: NetMaster Networking Solutions, Inc. X-Mailer: Mozilla 4.05 [en] (X11; I; Linux 2.0.33 i586) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Doing case-insensitive queries. Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I am trying to query a database case-insenstively on a char() field, and failing miserably. Could anyone direct me to some documentation that properly explains how to accomplish such a task in PostgreSQL. Items like ~* don't work when using the LIKE for me. Here is my current code segment on how I am doing this query with case sensitivity. $qstring = "select * from $database where vendor LIKE \'\%$inqstring\%\' ; "; $result = $con->exec($qstring); Can anyone tell me how I could query that without case-sensitivity? -- Dana M. Epp eppdm@netmaster.ca NetMaster Networking Solutions, Inc. http://www.netmaster.ca "Connecting networks to the Internet"