Hi John,

Hi finally resolved the problem by using SPT:

lcHld_Cat1 = "'F', 'G', 'H'": Passed from user interface

lcSQL = "Select * From DOCKET, Office_Docket, Docket_Org, Organization"
lcSQL = lcSQL+" WHERE DOCKET.DOCKET_ID=Office_Docket.DOCKET_FK"
lcSQL = lcSQL+" AND DOCKET.DOCKET_ID=DOCket_ORG.DOCKET_FK"
lcSQL = lcSQL+" AND ORGANIZation.ORG_ID = DOCket_ORG.ORG_FK"
lcSQL = lcSQL+" AND SUBSTRING(PROD_CAT_CD,1,1) IN (&lcHld_Cat1)"
gnHandle=sqlconnect("xxxxxx", "yyyyy", "??????")
=SQLExec(gnHandle, lcSQL, "vReports")


Thank you all.

Regards,

Paige