?SQLexec(nFileHandle,'select * from EMPLOYEE where EMPID in ("ABCO","CALPE","BEBO")','EMPINFO')>>Thanks for the response, Al.
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.