Frank - this might be the basis for solving the "The " problem... SELECT IF ( LEFT( title, 4)='The ', SUBSTRING(artist FROM 4), artist ) AS artist_sort_name FROM <table>
ORDER BY artist_sort_name or something like that... I'll try it later - my MySql is not strong. regards Phil -- Phil Leigh You want to see the signal path BEFORE it gets onto a CD/vinyl...it ain't what you'd call minimal...SB3+Stontronics PSU - Altmann JISCO/UPCI - TACT RCS 2.2X with Good Vibrations S/W - MF X-DAC V3/X-PSU/X-10 buffer (Audiocomm full mods)- Linn 5103 - Linn Aktiv 5.1 system (6x LK140's, ESPEK/TRIKAN/KATAN/SEIZMIK 10.5), Kimber & Chord cables ------------------------------------------------------------------------ Phil Leigh's Profile: http://forums.slimdevices.com/member.php?userid=85 View this thread: http://forums.slimdevices.com/showthread.php?t=41597 _______________________________________________ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss