title: Sharepoint 2010 FullTextSqlQuery using LIKE predicate does not find anything
body: <p>I'm trying to execute a search in SharePoint 2010 with the FullTextSqlQuery class:</p>
  
  <pre><code>using (SPSite site = new SPSite("http://localhost"))
  {
    using (FullTextSqlQuery query = new FullTextSqlQuery(site))
    {
      query.QueryText = "SELECT Title, FooText FROM scope() WHERE FooText = 'Foo2'";
      query.ResultTypes = ResultType.RelevantResults;
  
      //result output here...
    }
  }
  </code></pre>
  
  <p>The SQL statement used above returns some results. But with the following statement, replacing <code>'='</code> with <code>'LIKE'</code>, no results are returned:</p>
  
  <pre><code>SELECT Title, FooText FROM scope() WHERE FooText LIKE 'Foo2'
  </code></pre>
  
  <p>Note: FooText is a Managed Property of type Text and single valued.</p>