Alpha display of books

[Jeffrey Tucker]

Gary North is very upset with our display of literature by author - namely that it doesn't follow alphabetical conventions

This is obviously a db rule issue. Can anyone work with this ?

http://direct.mises.org/literature.aspx?action=author&ID=443

As you can see, we have some antique rules in here such as entries beginning with quotations come first because they are articles. This was fine 8 years ago but it no longer serves any purpose. It can go. But that still leaves a and a and the as problems.

Can anyone adjust the display rule to adhere to conventions? It becomes an issue mainly because we have SO MUCH STUFF!

---------- Forwarded message ----------
From: Gary North <gary...@garynorth.com>
Date: Fri, Oct 28, 2011 at 7:39 AM
Subject: RE: A donation
To: Jeffrey Tucker <jeffrey....@gmail.com>

OK, you can violate the universal rules of alphabetizing books.

 

Here is the rule:

 

I have searched for an exception for the "a" and "an," but I could find NONE.  I've tried to think up titles, like "An Affair to Remember," to see how it is cataloged.  I have used the Library of Congress, OCLC [World Cat], and several regional consortia.  I could find NO exceptions.  "A," "An," and "The" are always omitted for alphabetizing purposes.

 

 

 

____________________

[David Veksler]

Does anyone know how to do this in SQL?