title: Linq contains for SQL Like %
body: <p>Basically I'd like to use a LINQ statement for an sql like %. I thought .Contains would be appropriate but I don't get the right result.</p>
  
  <p>I have a model:</p>
  
  <pre><code>public class Model {
      public string Number { get; set; }
  }
  </code></pre>
  
  <p>Inside my function:</p>
  
  <pre><code>private List&lt;Model&gt; getSearchResults(List&lt;Model&gt; models) 
  {
      List&lt;Model&gt; result = models.Where(m =&gt; m.Number.Contains("3330")).ToList();
  
      return result;
  }
  </code></pre>
  
  <p>Inside my models list is definitively an entry with number 3330, but the returned result is empty. :(
  This should also work with .Contains("333"). But it doesn't.</p>