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
Alpha Sort W/o Articles Of Speech ("A", "The", "An")
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))));