>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

Why don't you use a sub-select
IN ( SELECT Codes.cCode from Codes )

HTH

Dan