In Query tool, is there a way to enter a long list of items at once?
I have a list of 100+ items in Excel. Would like to cut and paste it into Criteria in-list. But that does not work, because get syntax errors with quotes and parentheses. I can enter each item individually, but that is impractical. where oprid in ('aaa', 'bbb', … 'xxx') is what I want.
Thanks, Mark FSCM 9.2 Tools 8.58.08