Hi!

Try following:

SELECT *;
FROM Table;
WHERE INLIST(Field, ?&gcFieldTypes)

or even

gcFilter = "INLIST(Field, " + gcFieldTypes + ")"



SELECT *;
FROM Table;
WHERE ?&gcFieldTypes


I do not remember, however, if it should be '?&' or '&?', but there are only 2 combinations ;)


HTH.

>Hi
>
>I have a view that needs to be parameterized on an INLIST function, and I want to specify the INLIST contents with a Public Variable.
>
>So I tried setting the View up as:
>
>SELECT *;
> FROM Table;
> WHERE INLIST(Field, &gcFieldTypes)
>
>But with no joy.
>
>Any ideas on how I can achieve this, I do get the error, "Missing Operand".
>
>Thanks
>Kev