Search for text within a string - make dynamic

Hi,   I want to search for a particular word in a column within the table. I want to be able to pass in the search word as a variable value, so can make this dynamic, can it be done?   My code...