Received: from qi.com (qi.com [207.87.0.83]) by hub.org (8.8.8/8.8.8) with ESMTP id PAA25361 for ; Tue, 22 Sep 1998 15:56:41 -0400 (EDT) (envelope-from pgiagnoc@qi.com) Received: from gatekeeper.qi.com ([12.15.236.2]) by qi.com (8.8.4/8.7.3) with SMTP id PAA00460 for ; Tue, 22 Sep 1998 15:56:41 -0400 (EDT) Message-ID: <3608003B.2AA4ED27@qi.com> Received: from [192.168.1.47] by gatekeeper.qi.com via smtpd (for qi.com [207.87.0.83]) with SMTP; 22 Sep 1998 19:54:54 UT Date: Tue, 22 Sep 1998 15:53:31 -0400 From: Patrick Giagnocavo Organization: Quadrant International X-Mailer: Mozilla 4.06 [en] (Win98; I) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: case-insensitive SORT BY? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I am trying to ensure that when I do a SORT BY I get back the results in normal sorted order instead of case-sensitive order. The WHERE clause contains a LIKE '%..%' so I cannot use UPPER here in a way that does what I want. e.g. , given A, B, b, a as data, the normal SORT BY behavior returns a b A B How do I make it return a A b B instead? ./patrick