ORDER BY and ignoring the , a , and an

From: "Stoppel, Brett W" <bstoppel(at)ku(dot)edu>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: ORDER BY and ignoring the , a , and an
Date: 2001-03-29 19:43:52
Message-ID: AA33E10E16DAD411BDFD0008C7CF50E65636E0@hawk.mail.ukans.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is it possible to have the ORDER BY option ignore the articles "the ", "a ",
and "an " at the beginning of a VARCHAR, CHAR, TEXT, et cetera field? In
other words, I want my results to come back alphabetized, while ignoring the
aforementioned articles.

Brett Stoppel
Assistant Web Administrator
University of Kansas Academic Computing Services
bstoppel(at)ku(dot)edu - 785.864.0462 - www.ku.edu

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Perkins 2001-03-29 19:56:47 missing data
Previous Message Peter Eisentraut 2001-03-29 19:39:21 Re: missing data