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

Alpha sort w/o articles of speech ("A", "The", "An") (See related posts)

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))));
to sql mysql by simeonbeta2 on Fri Sep 02 00:36:43 -0400 2005

You need to create an account or log in to post comments to this site.


Click here to browse all 5137 code snippets

Related Posts