SELECT colorfield_part_id, pPaid, pName, CASE LEFT(pName,4) WHEN 'The ' THEN STUFF(pName, 1, 4, '') ELSE pName END nameWithoutThe, pURL, pPaid FROM colorfield_part ORDER BY nameWithoutThe

	ColorField Participants: #getParticipants.pName#