DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets has posted 5883 posts at DZone. View Full User Profile

Alpha Sort W/o Articles Of Speech ("A", "The", "An")

09.02.2005
| 3667 views |
  • submit to reddit
        I don't know if theres is a better way of doing this. I just sort by the title column after trimming leading An, A, The, and "...
select title from blog order by TRIM(leading 'The ' from TRIM(leading "A " from TRIM(leading "An " from TRIM(leading '"' from title))));