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