Article Mismatch (Artist)

If you want to check artists to see whether some entries have 'The ' while others don't:

First, define a user library field:

Tools->Options->Manage Library Fields

Add a 'New Field' called ArtistNoArticles and define it as a calculated field:

if(isequal(mid([artist],0,4),The ,1),mid([artist],4,-1),[artist])

Now use the smartlist:

[Media Type]=[Audio] ~sort=[Artist] ~nodup=[Artist],[ArtistNoArticles] ~dup=[ArtistNoArticles] ~sort=[ArtistNoArticles],[Artist]

This will display all artists with the same name but mismatched 'The ' article.