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
