Are you creating sql views here? Via an odbc datasource? If so, then the where clause is dependant on the database engine.

There has been a bit of talk about this recently, I haven't seen a really good solution mentioned yet.

If you are doing local views, ignore me. I blather on and on and on and on some times. :-) (But you could try where at(?myprod_cat, "FGH") > 0, not that it will work. I have no idea what I am talking about here. Is there a cancel button on the bottom of this form?)

>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