Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f93EYVn98847 for ; Wed, 3 Oct 2001 10:34:31 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f93EGCl37920 for pgsql-sql@postgresql.org; Wed, 3 Oct 2001 10:16:12 -0400 (EDT) (envelope-from news) From: "Jeff Boes" X-Newsgroups: comp.databases.postgresql.sql Subject: Re: ORDER BY case insensitive? Date: Wed, 03 Oct 2001 10:17:35 -0400 Organization: Nexcerpt, Inc. Lines: 17 Message-ID: <9pf6jc$150t$1@news.tht.net> References: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: scrappy@hub.org User-Agent: Pan/0.9.90 (Unix) To: pgsql-sql@postgresql.org X-Archive-Number: 200110/32 X-Sequence-Number: 4987 In article , "Bob Swerdlow" wrote: > How do I get the rows sorted in a case insensitive way? > SELECT * FROM MyTable ORDER BY Name; Try SELECT * FROM MyTable ORDER BY upper(Name); (or 'lower(Name)'). -- Jeff Boes vox 616.226.9550 Database Engineer fax 616.349.9076 Nexcerpt, Inc. jboes@nexcerpt.com