title: Lambda expression Contain () method does not work in Advantage Database 9?
body: <p>I am using Sybase Advantage Database 9.1</p>
  
  <p>and I try to use Lambda expression Contain method to retrieve data ,but it does not work.</p>
  
  <pre><code>var order = order.Where(x =&gt; x.name == "James");
  </code></pre>
  
  <p>it return 10 rows data.</p>
  
  <p>but If I change to</p>
  
  <pre><code>var order = order.Where(x =&gt; x.name.Contains("James"));
  </code></pre>
  
  <p>it return 0.</p>
  
  <p>x.name is string field.</p>
  
  <p>anybody know why it happened?</p>
  
  <p>How should I do to use Contain method?</p>
  
  <p>thanks</p>