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