Hi All,

Using VFP 6.0 I can pass dates as per below but how to pass items to the IN clause? Any help will be appreciated.

lcProdCds = "'F', 'G', 'H'"

WORKS:
and Actual_Office_Cplt_Dt > ldBegPer;
and Actual_Office_Cplt_Dt < ldEndPer;
AND SUBSTR(vOFF_DOC.PROD_CAT_CD,1,1) IN ("'F', 'G', 'H'");


DOES NOT WORK:
and Actual_Office_Cplt_Dt > ldBegPer;
and Actual_Office_Cplt_Dt < ldEndPer;
AND SUBSTR(vOFF_DOC.PROD_CAT_CD,1,1) IN ?(lcProdCds);

TIA.

Regards,

Paige