Excellent idea!

>Victor,
>You may be able to do this using the $ operator and adding a couple of delimiters around the field value.

>lcEmployeeString = "*12*,*35*"
>SELECT *;
>   FROM audits Audits;
>   WHERE '*' + transform(Audits.employee_id) + '*' $ ?lcEmployeeString

>HTH.
>
>>>You're trying to compare an integer to a string. You can do
>>>
>>>WHERE employee_id = 12 or employee_id = 35
>>>
>>>or
>>>
>>>WHERE TRIM(STR(employee_id)) IN ("12", "35")
>>>
>>>You can't do the = because VFP will look for the employee_id "12,35", not 12 or 35
>>
>>
>>Right....but my real problem is that the ("12","35") itself needs to be a variable....
>>
>>
>>>
>>>>employee_id field is Integer...
>>>>
>>>>This works:
>>>>
>>>>SELECT * from audits WHERE employee_id in (12,35)
>>>>
>>>>
>>>>This doesn't:
>>>>
>>>>lcEmployeeString = '12,35'
>>>>
>>>>SELECT *;
>>>> FROM audits Audits;
>>>> WHERE ALLTRIM(STR(Audits.employee_id)) IN (?lcEmployeeString)
>>>>
>>>>
>>>>I also tried this:
>>>>lcEmployeeString = "'12','35'"
>>>>lcEmployeeString = '12,35'
>>>>lcEmployeeString = "('12','35')"
>>>>
>>>>Can I even do this in a remote view?
>>>>
>>>>Thanks!