SELECT colorfield_part_id, pPaid, pURL, pEmail, pContactName, 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# Contact: #getParticipants.pContactName#, #getParticipants.pEmail# Contact: #getParticipants.pEmail# ^ Back to Top