Flagging Executives with SQL

Here's a bit of Oracle SQL code that will flag executives in your data, for use as a potentially very important independent variable in an analysis.

SELECT id_number, 
       report_name,
       business_title,
       'Y' as executive
  FROM your_table
 WHERE business_title like ('Part%')
    or business_title like ('Prin%')
    or business_title like ('Pres%')
    or business_title like ('Owne%')
    or business_title like ('Foun%')
    or business_title like ('Vice%')
    or business_title like ('Chie%')
    or business_title like ('Chai%')
    or business_title like ('VP%')
    or business_title like ('V.P.%')
    or business_title like ('C.E.%')
    or business_title like ('COO%')
    or business_title like ('CFO%')
    or business_title like ('CIO%')
    or business_title like ('CEO%')
 ORDER BY id_number