title: how to use split function in where used LIKE operator
body: <p>I want use function split in my query that contain <strong>LIKE</strong> operator.</p>
  
  <pre><code> SELECT * FROM Tbl_News n WHERE n.Date &gt;= @Fromdate AND n.Date &lt;= @Todate 
   AND n.Title LIKE '%' + (SELECT Item FROM dbo.SplitString(@key, ',')) + '%' 
  </code></pre>
  
  <p>type n.Title is nvarchar.
  but raise this error:</p>
  
  <blockquote>
    <p>Subquery returned more than 1 value. This is not permitted when the
    subquery follows =, !=, &lt;, &lt;= , >, >= or when the subquery is used as
    an expression.</p>
  </blockquote>