-- find by first name select * from wnp_member_mstr wmm where upper(wmm.member_first_name) like '%ROGER%'; -- find by last name select * from wnp_member_mstr wmm where upper(wmm.member_last_name) like '%MILLER%'; -- find by employee id select * from wnp_member_mstr wmm where upper(wmm.employee_network_id) like '%U022554%'; -- find by email select * from wnp_member_emails wme join wnp_member_mstr wmm on wme.wnp_id = wmm.wnp_id where upper(email_address) like '%ROGER.MILLER@PUREPOWERTECHNOLOGIES.COM%';