title: T-SQL and the WHERE LIKE %Parameter% clause
body: <p>I was trying to write a statement which uses the WHERE LIKE '%text%' clause, but I am not receiving results when I try to use a parameter for the text.  For example, this works:</p>
  
  <pre><code>SELECT Employee WHERE LastName LIKE '%ning%'
  </code></pre>
  
  <p>This would return users Flenning, Manning, Ningle, etc.  But this statement would not:</p>
  
  <pre><code>DECLARE @LastName varchar(max)
  SET @LastName = 'ning'
  SELECT Employee WHERE LastName LIKE '%@LastName%'
  </code></pre>
  
  <p>No results found.  Any suggestions? Thanks in advance.</p>