select cho_Type, * from tbl_CHO_Operators
where cho_recordSource = 'CMSH' or cho_recordSource = 'CMS' or cho_recordSource like 'world casino directory%' or cho_recordSource = 'IPEDS' or cho_recordSource = 'NCES'

update tbl_CHO_Operators
set cho_Type = 'I'
where cho_recordSource = 'CMSH' or cho_recordSource = 'CMS' or cho_recordSource like 'world casino directory%' or cho_recordSource = 'IPEDS' or cho_recordSource = 'NCES'