Received: from lscorp.com (poohbah.lscorp.com [207.152.64.2]) by hub.org (8.8.8/8.7.5) with ESMTP id AAA20434 for ; Sun, 5 Jul 1998 00:23:14 -0400 (EDT) Received: from [207.152.64.133] by lscorp.com with SMTP (Eudora Internet Mail Server 1.2); Sat, 4 Jul 1998 23:21:23 -0500 X-Sender: lynch@poohbah.lscorp.com Message-Id: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" To: pgsql-sql@postgresql.org From: lynch@lscorp.com (Richard Lynch) Subject: A, An, and The, out of Alphabetical order Date: Sat, 4 Jul 1998 23:21:23 -0500 I probably need a whole new column for alphabetical ordering, but... I want something like this for now (I think): select band, ltrim(band, 'THE ') as alpha from bands order by alpha; except I only want a match on 'THE ', not any any character within it, which is what ltrim does... Is there something like what I want that's easy to do? [If it's way hard, I'll just add a column.] -- -- -- "TANSTAAFL" Rich lynch@lscorp.com