title: Query with LIKE statement for any of the words, not whole
body: <pre><code>SELECT *
  FROM Products
  WHERE Name LIKE '%' +
      (SELECT TOP 1 Gift.Name FROM Gift WHERE Id = 65)
       + '%'
  </code></pre>
  
  <p>Subquery returns sth like "toy gun". Some of them even consists of three or more words. Obviously main query looks for Names that include "toy gun".
  What I want to do is return all results for "toy" or "gun".</p>
  
  <p>Any suggestion?</p>