Toad Data Point 5.7 IN statement incorrectly parses names

When using the IN operator in the WHERE clause in the Query Builder, it does this:

should be: IN ('Murphy, Sharon', 'Hockman, Valerie')
and when I look at the sql,
it is: IN ('Murphy', 'Sharon', 'Hockman', 'Valerie')

How can I get Toad Data Point to correctly parse names in the IN statement?

Thank you! Best, Sharon

Not able to reproduce this, Sharon. See snap below of a test I just did.
What database? Column datatype?
Might help if you outline in detail the steps you're using to reach your outcome.

Thank you Gary. I have attached a couple of screenshots for you.

See the bottom of the sql….

SELECT DISTINCT BILL_AREA.CLINICAL_DEPT_DISPLAY,
BILL_AREA.SECTION_DISPLAY,
FACILITY.LOCATION_LONG_DESC,
PATIENT.CPI_NUM_PADDED,
CAL_SVC_DATE.ORACLE_DATE AS "Service Date",
REVC_AR.AR_TYPE_DISPLAY,
REVC_TRANSACTION.REVC_TRANS_AMT,
REVC_CHG_LINE.REVC_CHG_LN_BAL,
CDM.CDM_CD,
CDM.CDM_HSDW_DESC,
CDM.CDM_CPT4,
CAL_POST_DATE.ORACLE_DATE AS "Post Date",
PROVIDER_BILL_MD.FULL_NAME AS "Billing Provider",
PROVIDER_BILL_MD.UMHS_DR_NUM AS "Billing Provider Dr Num",
PROVIDER_SVC_MD.FULL_NAME AS "Service Provider",
PROVIDER_SVC_MD.UMHS_DR_NUM AS "Service Provider Dr Num",
PAYOR_PLAN_ACT.PAYOR_DESC,
PAYOR_PLAN_ACT.BENEFIT_PLAN_DESC,
REVC_TRANSACTION.REVC_TRANS_PX_UNITS,
REVC_TRANSACTION.REVC_ACCOUNT_TYPE_IND,
REVC_TRANSACTION.REVC_TRANS_CHG_CSN,
REVC_TRANSACTION.REVC_ACCOUNT_NUM,
REVC_TRANSACTION.REVC_TRANS_COINS_ACT_AMT,
REVC_AR.AR_TYPE_CATEGORY_DISPLAY,
CAL_SVC_DATE.CAL_YEAR,
CDM.PX_CATEGORY_DESC,
REVC_CHG_LINE.REVC_CHG_LN_CHG_EDIT_AMT,
FACILITY.DEPT_LONG_DESC,
PATIENT.PATIENT_FULL_NAME
FROM ((((((((((SDW.REVC_TRANSACTION REVC_TRANSACTION
INNER JOIN
SDW.PATIENT PATIENT
ON (REVC_TRANSACTION.PATIENT_KEY = PATIENT.PATIENT_KEY))
INNER JOIN
SDW.FACILITY FACILITY
ON (REVC_TRANSACTION.FACILITY_KEY = FACILITY.FACILITY_KEY))
INNER JOIN
SDW.BILL_AREA BILL_AREA
ON (REVC_TRANSACTION.BILL_AREA_KEY = BILL_AREA.BILL_AREA_KEY))
INNER JOIN
SDW.CDM CDM
ON (REVC_TRANSACTION.CDM_KEY = CDM.CDM_KEY))
INNER JOIN
SDW.CAL_POST_DATE CAL_POST_DATE
ON (REVC_TRANSACTION.CAL_POST_DATE_KEY =
CAL_POST_DATE.CAL_POST_DATE_KEY))
INNER JOIN
SDW.CAL_SVC_DATE CAL_SVC_DATE
ON (REVC_TRANSACTION.CAL_SVC_DATE_KEY =
CAL_SVC_DATE.CAL_SVC_DATE_KEY))
INNER JOIN
SDW.PROVIDER_BILL_MD PROVIDER_BILL_MD
ON (REVC_TRANSACTION.PROVIDER_BILL_MD_KEY =
PROVIDER_BILL_MD.PROVIDER_BILL_MD_KEY))
INNER JOIN
SDW.PROVIDER_SVC_MD PROVIDER_SVC_MD
ON (REVC_TRANSACTION.PROVIDER_SVC_MD_KEY =
PROVIDER_SVC_MD.PROVIDER_SVC_MD_KEY))
INNER JOIN
SDW.PAYOR_PLAN_ACT PAYOR_PLAN_ACT
ON (REVC_TRANSACTION.PAYOR_PLAN_ACT_KEY =
PAYOR_PLAN_ACT.PAYOR_PLAN_ACT_KEY))
INNER JOIN
SDW.REVC_AR REVC_AR
ON (REVC_TRANSACTION.REVC_AR_KEY = REVC_AR.REVC_AR_KEY))
INNER JOIN SDW.REVC_CHG_LINE REVC_CHG_LINE
ON (REVC_TRANSACTION.REVC_ACCOUNTS_KEY =
REVC_CHG_LINE.REVC_ACCOUNTS_KEY)
AND (REVC_TRANSACTION.REVC_TRANS_NUM =
REVC_CHG_LINE.REVC_CHG_LN_TRANS_NUM)
WHERE (REVC_TRANSACTION.REVC_ACCOUNT_TYPE_IND = 'PB')
AND (REVC_AR.AR_TYPE_CATEGORY_DISPLAY = 'CHARGE')
AND (CAL_SVC_DATE.CAL_YEAR = 2018)
AND (REVC_CHG_LINE.REVC_CHG_LN_CHG_EDIT_AMT = 0)
AND (FACILITY.DEPT_LONG_DESC IN ('CHC',
'KEB',
'KEC',
'KEM',
'OPTICAL',
'OPTICAL',
'OPTICAL',
'OPTICAL',
'SHOP',
'SHOP',
'SHOP',
'SHOP'))
ORDER BY "Service Date" ASC