# SQL Question

**URL:** <https://forum.kirupa.com/t/sql-question/227229>\
**Category:** Uncategorized\
**Created:** [May 28, 2007, 5:15pm UTC](https://forum.kirupa.com/t/sql-question/227229 "2007-05-28T17:15:17Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ben\_Smith](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/ben_smith/32/1118_2.png) [@Ben\_Smith](https://forum.kirupa.com/u/Ben_Smith)\
**Post date:** [May 28, 2007, 5:15pm UTC](https://forum.kirupa.com/t/sql-question/227229/1 "2007-05-28T17:15:17Z")

</div>

You know in iTunes, where the artists are ordered alphabetically and any artists with ‘The’ at the front of them are ordered by the actual noun in the name, is this possible in SQL?

Or would I have to do it manually in PHP.

For example:

Asian Kung-Fu Generation  
The Ataris  
Athlete

Thanks,  
Ben