title: LIKE expression does not work a query in C#
body: <p>I want to search the records that have 3 or more '#'.</p>
  
  <p>In MSAccess I can Write this and show me the results:</p>
  
  <pre><code>SELECT * FROM AlmLotes WHERE Lote LIKE '[#][#][#]*';
  </code></pre>
  
  <p>But in C# don't works.</p>
  
  <pre><code>DataTable dtResultats = new DataTable();
  
  string strConnectionSource = MYCONNECTIONSTRING
  
  OleDbConnection connAccess = new OleDbConnection(strConnectionSource);
  connAccess.Open();
  
  string strSQL = "SELECT * FROM AlmLotes WHERE Lote LIKE '[#][#][#]*'";
  
  OleDbCommand cmd = new OleDbCommand(strSQL, connAccess);
  OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(cmd);
  dtResultats = new DataTable();
  
      try
      {
          myDataAdapter.Fill(dtResultats);
      }
      catch (Exception e)
      {
          Console.WriteLine(e.Message);
      }
  
      for (int i = 0; i &lt; dtResultats.Rows.Count; i++)
      {
          var rows = dtResultats.Rows[i];
          for (int z = 0; z &lt; dtResultats.Columns.Count; z++)
          {
              Console.WriteLine(dtResultats.Columns[z].ColumnName + ": " + rows[z] + Environment.NewLine);
          }
      }
  Console.ReadKey();
  </code></pre>
  
  <p>The SQL Query in MSAcces show me 5 results.
  THE SQL QUery in C# show me 0 results.</p>