The keyword "manager, director, President, secretary of the party"

Find the characters: "test test test, chairman of the"

Can use the SQL statement judge of character appeared any keyword

 select PATINDEX ('/manager, director, President, secretary of ', 'test test test chairman') 

This way only judge the individual characters, need to decide character by commas

thank you