title: tsql IN not working properly if passed as parameter
body: <p>I have a sitution where I need to pass a string in order to do an IN</p>
  
  <pre><code>    declare @searchString varchar(50)
      set @searchString = ' ''Nestle'',''UFI'' '
  
      select * from tbl1 where CompanyName IN (@SearchString) 
  </code></pre>
  
  <p>does't work.</p>
  
  <p>But if I do:</p>
  
  <pre><code>    select * from tbl1 where CompanyName IN ('Nestle','UFI')
  </code></pre>
  
  <p>It works fine. I cannot understand why one work and the other doesn't</p>