title: Filter data by keywords and note where they were found
body: <p>so i have a query at the moment. </p>
  
  <pre><code>SELECT *
  FROM TABLE1
  </code></pre>
  
  <p>It yields besides other stuff 4 colums which contain text "Textbox1" "Textbox2" "Textbox3" "Textbox4".</p>
  
  <p>I now want to filter this query by keywords in those text boxes. Basically the user can enters 0 to 5 keywords and the rows from TABLE1 should only show if at least one keyword was found in one of the textboxes. Also a new column should be added that for every keyword that was found in a textbox should say which keyword and in which textboxes it was found. </p>
  
  <p>The query itself will later run in SSRS which is where the user puts in the keywords. So the keywords are accasable as varchars. For the query you can use this:</p>
  
  <pre><code>DECLARE @Keyword1 AS VARCHAR(100) = '';
  DECLARE @Keyword2 AS VARCHAR(100) = '';
  DECLARE @Keyword3 AS VARCHAR(100) = '';
  DECLARE @Keyword4 AS VARCHAR(100) = '';
  DECLARE @Keyword5 AS VARCHAR(100) = '';
  </code></pre>
  
  <p>Thanks for any help. </p>
  
  <p>Edit:</p>
  
  <p><a href="https://i.stack.imgur.com/DnAMb.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DnAMb.png" alt="Example with desired result"></a></p>