title: How to use a LIKE in sp_executesql? I can't construct the statement
body: <p>I want to use a LIKE in sp_executesql but I can't construct the statement,
  I receive errors, this is a simple example just to show the case:</p>
  
  <pre><code>SELECT @SqlStatement = @SqlStatement +    
     (CASE @SearchType  
      WHEN 'L' THEN  
        + N' AND aa.Location = COALESCE(@SearchCriteria, '''') '
      WHEN 'M' THEN
   + N' AND aa.ManufactureName LIKE COALESCE(@SearchCriteria, '''') '
      WHEN 'P' THEN  
        + N' AND OH.PONumber = COALESCE(@SearchCriteria, '''')'
     END) 
  </code></pre>