WNP@HWPROD1> show user USER is "WNP" WNP@HWPROD1> select * from wnp_member_mstr wmm 2 where upper(wmm.member_first_name) like '%JULIE%'; WNP_ID EMPLOYEE_NETWORK_ID COMPANY_ID ---------- ---------------------------------------- ---------- MEMBER_FIRST_NAME MEMBER_LAST_NAME ------------------------------ ------------------------------ MIDDLE_INITIAL DATE_OF_B DATE_OF_DEATH G MARITAL_STATUS_ID -------------------- --------- ------------------ - ----------------- RELATIONSHIP_ID ETHINICITY_ID EDUCATION_ID LANGUAGE_ID PASSWORD I --------------- ------------- ------------ ----------- -------------------- - NSH -------------------------------------------------- A000142201 A000000241 JULIE AKERS R 21-JUL-78 F 2 2 Y A000138601 A000000241 JULIE BIGGS A 03-APR-63 F 2 2 Y A000110501 A000000241 JULIE NEWELL A 10-JUL-81 F 2 2 Y A000182200 u00s506 A000000241 Julie Dorris A 11-APR-55 F 61 1 Y A000208201 A000000241 Julie Esparza C 13-OCT-86 F 2 2 Y A000240900 yyyjgb1 A000000241 Julie Harris G 23-JAN-62 F 2 1 Y A000236800 u00jxsm A000000241 Julie Stone D 02-NOV-80 F 2 1 Y A000216401 A000000241 Julie Peacock 09-JAN-83 F 2 2 Y A000278900 u00jab9 A000000241 Julie Kaludis A 20-FEB-56 F 2 1 Y A000324001 0120898-usmcmom A000000241 JULIE HARVEY R 13-OCT-66 F 2 2 Y A000328501 A000000241 JULIE RUSKE A 22-DEC-63 F 2 2 Y A000330800 u00jle1 A000000241 Julie Espich L 31-MAR-67 F 2 1 Y A000390201 A000000241 Julie Fincher A 09-JUN-76 F 2 2 Y A000357801 A000000241 JULIE SHOEMAKER M 30-NOV-68 F 2 2 Y A000360301 0100221-u00jmt4 A000000241 JULIE TRUDO M 23-SEP-67 F 2 2 Y A000402301 A000000241 JULIE MCCORMICK A 06-FEB-61 F 2 2 Y A000413401 A000000241 JULIE BEASINGER D 04-DEC-74 F 2 2 Y A000429501 A000000241 JULIE DOBBS P 26-SEP-69 F 2 2 Y A000420901 A000000241 JULIE KNOBLAUCH A 27-FEB-61 F 2 2 Y A000481201 A000000241 JULIE JONES A 03-AUG-71 F 2 2 Y A000482101 0104296-Jewels87 A000000241 JULIE BECK K 02-JAN-69 F 2 2 Y A000525101 0101145-Jab51758 A000000241 JULIE BIELAGA A 17-MAY-58 F 2 2 Y A000511201 A000000241 JULIE RIEMEN E 01-APR-67 F 2 2 Y A000556601 A000000241 Julie King A 06-DEC-84 F 2 2 Y A000537101 A000000241 JULIE DICKERSON A 03-MAY-73 F 2 2 Y A000547901 0130326-julsmith A000000241 JULIE SMITH L 25-MAR-71 F 2 2 Y A000628601 A000000241 Julie Payne J 20-APR-73 F 2 2 Y A000686801 A000000241 JULIE JONES A 04-JUL-57 F 2 2 Y A000730600 u00jasx A000000241 Julie Stouder 25-NOV-66 F 2 1 Y A000718700 u00jao4 A000000241 Julie Overton A 16-MAY-72 F 2 1 Y A000971401 A000000241 Julie Hall A 18-MAY-71 F 2 2 Y A000948501 0130907-RatherBSewing A000000241 JULIE BAIR C 09-OCT-71 F 2 2 Y A001105401 A000000241 Julie Mearing G 20-APR-59 F 2 2 Y A000871701 A000000241 JULIE TURNER A 30-MAY-69 F 2 2 Y A000786901 0172225-ejwagner A000000241 Julie Wagner 14-APR-77 F 2 2 Y A000789401 A000000241 Julie Austin A 18-MAR-67 F 2 2 Y A000806901 A000000241 JULIE JETER 20-FEB-73 F 61 2 Y A000989801 A000000241 JULIE RAPER D 17-AUG-77 F 2 2 Y A000903801 A000000241 JULIE BURES M 14-JUL-58 F 2 2 N A000558201 A000000241 JULIE BAUR K 03-NOV-72 F 2 2 N A001013801 A000000241 JULIE COAN S 16-DEC-79 F 2 2 Y A001044300 u00jasb A000000241 Julie Wassmer A 08-OCT-80 F 2 1 Y A001067701 A000000241 Julie Burch A 13-APR-61 F 2 2 Y 43 rows selected. WNP@HWPROD1> select * from wnp_member_mstr wmm 2 where upper(wmm.member_last_name) like '%GENTILE%'; no rows selected WNP@HWPROD1> select * from wnp_member_mstr wmm 2 where upper(wmm.employee_network_id) like '%0173637%'; no rows selected WNP@HWPROD1> spool off