title: Where charindex not working in SQL Server
body: <p>Here is the query, it is returning zero matches:</p>
  
  <pre><code>select * 
  from CompleteSet
  where CHARINDEX(CompleteSet.Problem,'aaa') &gt; 0
  </code></pre>
  
  <p>I know that I definitely have entries with <code>aaa</code> in <code>CompleteSet</code>.</p>
  
  <p>I cannot figure out what is going on.</p>