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.