title: SQL Server date between LIKE
body: <p>Please help me how to insert <code>LIKE %</code> in date between. Example is: </p>
  
  <pre><code>SELECT * 
    FROM table 
   WHERE Date BETWEEN '" &amp; startDate &amp; "%'" AND '" &amp; endDate &amp; "%'" 
  </code></pre>
  
  <p>So in this code where i should put <code>LIKE</code> so that data will appear?</p>
  
  <p>example if i set like this </p>
  
  <pre><code> SELECT * 
   FROM table 
   WHERE Date LIKE '" &amp; startDate &amp; "%'" 
  </code></pre>
  
  <p>it's working..<code>LIKE</code> meant read either startdate or %..for starting it will read %</p>