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
