title: sql "LIKE" Query syntax
body: <p>what is the wrong in this Query ?</p>
  
  <pre><code>string command_get_pay = "select Credit 
                            from Update_Company_Credit 
                            where (Update_Date LIKE '%" +
      System.DateTime.Today.ToShortDateString() + "%')";
  </code></pre>