Never been to DZone Snippets before?

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

About this user

metapundit http://metapundit.net/sections/blog

« Newer Snippets
Older Snippets »
Showing 1-1 of 1 total  RSS 

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 "...
   1  
   2  select title from blog order by TRIM(leading 'The ' from TRIM(leading "A " from TRIM(leading "An " from TRIM(leading '"' from title))));
to sql mysql by simeonbeta2 on Sep 02, 2005
« Newer Snippets
Older Snippets »
Showing 1-1 of 1 total  RSS