ISOLATING A BLOCK OF TEXT FROM A LARGER BLOCK OF TEXT WITHIN 1 COLUMN

I'm a novice with SQL, but hoping someone can help. It's for a cancer project, so you will be helping us save lives with your efforts. Any assistance would be greatly appreciated.

I really need to isolate the query to a specific block of text within a larger block of text. The block of text I would like to do my case statement on looks something like this. I would like to search the text only between "TITLE OF BLOCK" and "Signed By." All the text is in one column called "Results" in a table called "Report." If I see WORD2 AND WORD4 in any combination, then I'd like to count it as 1 (else 0) in a column called "WORDS2AND4" in a table called "ReportBrief."