AFAIK, it cannot be done for IN operator for more than 1 value.
>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.
>
--sb--