Re: Selecting all variations of job title in a list

[Rich Shepard]

On Tue, 25 Nov 2025, Adrian Klaver wrote:

Something like?:

select 'Env mgr.' ilike ANY(ARRAY['Asst Gen Mgr.', 'Env Mgr.', 'Gen Mgr.', 'Mgr.','Plant Mgr.']);

Adrian,

Hadn't thought of this.

Your, and Ron's, answers taught me that the answer to my question is 'no,
there is no shortcut.' :-)

Thanks,

Rich