-- find by first name select * from wnp_member_mstr wmm where upper(wmm.member_first_name) like '%JULIE%'; -- find by last name select * from wnp_member_mstr wmm where upper(wmm.member_last_name) like '%GENTILE%'; -- find by employee id select * from wnp_member_mstr wmm where upper(wmm.employee_network_id) like '%0173637%';