I am trying to filter out all occurrence of Internship in table column using the following query , howver for some reason, some cases of Inern occurences are not getting captured. Does anyone have any suggestions on how to make this logic capture all cases?
select distinct
wc_application_event_f.pi_candidate_num,
wc_application_event_f.job_info_row_wid,
WC_JOB_INFORMATION_D.job_family_name,
wc_job_information_d.title,
wc_job_information_d.organization_name
from wc_application_event_f
INNER join wc_job_information_d
on wc_application_event_f.job_info_row_wid= wc_job_information_d.row_wid
where pi_his_itm_app_trk_sts_name = 'Hired - External'
and pi_his_itm_app_trk_step_name = 'Hire'
AND ( TITLE LIKE '%Intern %'
or title like '%Internship%' );