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


>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!