Re: Selecting all variations of job title in a list

On Tue, 25 Nov 2025, Ron Johnson wrote:

> Failed clarity on my part.  The "OR clauses" are within the regex string.

Ron,

That's okay.

> Note that The Relational Way of doing this is for everyone to have
> title_code in their "person" record, and the "title" table will have, in
> addition to the title_code PK column, the title_description,
> title_abbreviation ( 'Asst Gen Mgr.', 'Env Mgr,', 'Gen Mgr,'. 'Mgr,',
> 'Plant Mgr.') and title_group columns. All those manager titles would be
> in the same group. You'd then join "person" to "title" and filter where
> title_group="mumble".

That's impractical. The title table would be hundreds of rows long, most
having only 1 or 2 references. Companies don't have standard titles for
everyone.

Rich