There have been several question lately at the desk and through e-mail from students wanting a list of all CFO's or all Investor Relations Officers or all the names of officers in another type of corporate management position. Peggy and Linda and I tested a few databases looking for the best one to answer this type of question. Mergent Online in their Executive Search tab allows searching by job function but you must type in all variations of the job title.
A better source is the Corporate Affiliations database. Use their advanced search page. When you search by job title they actually pull all jobs together with a "value" or number regardless of the the title used. This means that when you put in the value for Investor relations you will be searching for all the investor relations personnel regardless of whether they are VP's, managers, directors, etc. You can limit your results to public or private companies and parent or subsidiaries. Results can be downloaded into Excel. You can save either the company list or the "people" list. The people list includes name, title, company name, address, phone & fax, company URL and corporate e-mail address as well as a sales figure and the number of employees in the company.