Alpha Sort W/o Articles Of Speech ("A", "The", "An")
Join the DZone community and get the full member experience.Join For Free
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))));