Hi All,

I have searched around but not really found an answer to this. For a 
project I am working on the customer wants a list of publications to be 
sorted alphabetically, but ignoring the definite/indefinite articles 
"the/a/an".

Eg, the list should sort like

   Adherence to ...
   The Effects of ...
   A Low Participation Rate ...
   Trends in ...
   Understanding ...
   What Stops ...

Is there a way of doing this using the ORM or a custom manager without 
having to write custom SQL every time I need to get a list of publications?

I found the following page which has a method of doing it for MySQL:

http://expressionengine.com/wiki/Sort_Entries_by_Title_Ignoring_The_A_An/


-- 
Darryl Ross, VK5LBJ
AFOYI, Information Technology Solutions
e: [email protected]
p: +61 8 7127 1831
f: +61 8 8425 9607

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to