Rick's example, trimmed down to just the final three character bit, can be used as a category in a category view too, which is what Sgucci99 is using.
If he/she were to set that that up as the first category, they could then click through "Bee" to get at all the Beethoven goodness, "Bac" to get at all the Bach stuff, etc. etc.
It will add an extra level of browsing, but should still be a solution that works pretty well, don't you think?
Right click on the view in the tree, customise view, in the category section, click the 'add' button, select "Expression", give it a name, paste in the expression code, press OK, move it to the top of the categories list, press OK again, job done.
Expression Code: if(isequal(mid([artist],0,4),the/ ,1),mid([artist],4,3),if(isequal(Mid([artist],0,1),1,6),0 - 9,Mid([artist],0,3))
How does that work for you?