-- find by first name select * from wnp_member_mstr wmm where upper(wmm.member_first_name) like '%KATHY%'; -- find by last name select * from wnp_member_mstr wmm where upper(wmm.member_last_name) like '%VOIROL%';