>AFAIK, it cannot be done for IN operator for more than 1 value.
>
That's what I was afraid of. Thanks for the info.






>>Perhaps I didn't explain it properly. I don't want to build a user interface which gets the names of the employees and then passes them to SQLEXEC(). I want to find some way for the SQLEXEC() statement to see the need for an input variable and then evaluate it properly as the arguments for IN().
>>
>>Same question from a different angle.
>>
>>Let's say I'm working in the View Designer. I've set up my Field List and Join and now I'm working in the Filter Tab. I select a field (employee) and make the criteria IN. When I USE the view, I want to be able to enter a list of employees that will be evaluated for IN().
>>I haven't been able to find anyway to get more than the first name to be part of the result set.
>>
>>Sorry if I wasn't clear enough. I hope this explanation is better.
>>