title: SQL Contains Question
body: <p>Can someone explain this to me? I have two queries below with their results.</p>
  
  <hr>
  
  <p><strong>query</strong>:</p>
  
  <pre><code>select * from tbl where contains([name], '"*he*" AND "*ca*"')
  </code></pre>
  
  <p><strong>result-set</strong>:</p>
  
  <blockquote>
    <p>Hertz Car Rental</p>
    
    <p>Hemingyway's Cantina</p>
  </blockquote>
  
  <hr>
  
  <p><strong>query</strong>:</p>
  
  <pre><code>select * from tbl where contains([name], '"*he*" AND "*ar*"')
  </code></pre>
  
  <p><strong>result-set</strong>:</p>
  
  <blockquote>
    <p>nothing</p>
  </blockquote>
  
  <hr>
  
  <p>The first query is what I would expect, however I would expect the second query to return "Hertz Car Rental". Am I fundamentally misunderstanding how '*' works in full-text searching?</p>
  
  <p>Thanks!</p>