Hi, I have to correct this issue:

Beatles, The
Doors, The
Cranberries, The

I have to move ''The'' at the beginning (The Beatles). I have to do this in order to XBMC can scrape this artists correctly.

I have 140,000 mp3, so is gonna be a long work, to make my life easy I want to ''filter'' only the artists in the situation

I am using the filter: the%artist% but I am getting nothing, 0 result
If I use ''The'' without the cotes I get like 70,000 results

I will appreciate your comments and help, regards

Got it:

%artist% HAS "the"

What about:
Tom Petty and the Heartbreakers
Booker T. & the MG's
Echo & the Bunnymen
Huey Lewis & the News

Better to use:

%artist% HAS ", The"