title: TSQL PATINDEX Searching exact value in a comma seperated list
body: <p>Hi i need to control if my value is exists in a comma seperated list.</p>
  
  <p>For example</p>
  
  <pre><code>DECLARE @list NVARCHAR = '6,3,67,34';
  
  SELECT Column1, Column2 FROM Table1
  WHERE PATINDEX ('%' + CONVERT(NVARCHAR, Table1.ID) + '%', @list)
  </code></pre>
  
  <p>It should return rows which ID field is 6, 3, 67 or 34.</p>
  
  <p>How can i do with or without PATINDEX?</p>