title: How can I use wildcards in EF Core Like function
body: <p><strong><code>.NET Core 2.2.0</code></strong></p>
  
  <p>I would like to use Wildcards in <code>EF Core</code>'s Like function, but it doesn't work the way I expect and I've read about in some posts (best example <a href="https://stackoverflow.com/questions/45708715/entity-framework-ef-functions-like-vs-string-contains">here</a>)</p>
  
  <p><strong>My Code:</strong></p>
  
  <pre><code>List&lt;string&gt; list = new List&lt;string&gt;();
  list.Add("Hi fransois");
  list.Add("Hi francois");
  list.Add("Hi françois");
  
  List&lt;string&gt; testa = list.Where(a =&gt; EF.Functions.Like(a, "%francois%")).ToList();      // Results in 1 hit, as expected
  List&lt;string&gt; testb = list.Where(b =&gt; EF.Functions.Like(b, "%françois%")).ToList();      // Results in 1 hit, as expected
  List&lt;string&gt; testc = list.Where(c =&gt; EF.Functions.Like(c, "%fran[cç]ois%")).ToList();   // Results in 0 hits, EXPECTED: 2
  </code></pre>
  
  <p>Why doen't this work as expected?</p>