title: MS-SQL CHARINDEX fails to find string
body: <p>I amm using MS-SQL EXPRESS 2012 (no full-text-indexing) and while I can get results when using LIKE on several tables when searching for a keyword using my search form, I cannot get LIKE, CHARINDEX or PATINDEX to find for example, "34", when searching the Skillset column that is comprised of data that looks like...</p>
  
  <pre><code>23, 34, 78
  </code></pre>
  
  <p>Have tried the following:</p>
  
  <pre><code>Select CHARINDEX('" + strKeyword + "', Skillset) &gt; 0
  Select Skillset LIKE '%" + strKeyword + "%'
  Select Skillset LIKE '%" + Replace(strKeyword, "'", "''") + "%'
  </code></pre>
  
  <p>Otherwise the third line works on all other columns. The Skillset column is formatted as varchar(150) just like the other columns containing searchable data.</p>
  
  <p>Why doesn't it work with numbers in a column that is storing array type data?</p>