Your Welcome

>Thank you. That was exactly it!
>
>>Ashley
>>
>>I am not sure about Access but in a SQL database use have to use ' around strings.
>>

?SQLexec(nFileHandle,"select * from EMPLOYEE where EMPID in ('ABCO','CALPE','BEBO')",'EMPINFO')

>>
>>>Hi Al,
>>>
>>>Tried this with no luck (returns -1 if I add the WHERE .. IN clause, 1 - success if I remove it)
>>>

?SQLexec(nFileHandle,'select * from EMPLOYEE where EMPID in ("ABCO","CALPE","BEBO")','EMPINFO')

>>>>>Thanks for the response, Al.
>>>>>Could you give me an example of the 'IN' syntax?
>>>>
>>>>From VFP7 help for SELECT - SQL, Example 7:

Example 7 displays FilterCondition in the form of FieldName [NOT] IN Value_Set
>>>>
>>>>When the filter condition includes IN, the field must contain one of the values before its record is included in the query results.
>>>>
>>>>customer.postalcode NOT IN ("98052","98072","98034")

This example uses character values. If your case uses numeric values, remove the quotes. You would typically build the entire SELECT command as a string variable and pass that as one of the parameters to your SQLEXEC() function call.