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!