title: SQL SELECT Between 2 Dates
body: <p>I am having a real issue with trying to query my database by selecting the data between 2 dates.</p>
  
  <p>Below is the query I am using within my VB .NET project.</p>
  
  <p><code>WHERE [BuildID] &gt; 0 AND [EndDate] BETWEEN '01/07/2014' and '31/07/2014'</code></p>
  
  <p>The date format is set to dd/mm/yyyy and the column type is VARCHAR(10)</p>
  
  <p>When I run this query, it brings back all the data in my database, basically it selects all.</p>
  
  <p>I have tried several methods such as <code>[EndDate] &gt;= '01/07/2014' and [EndDate] &lt;= '31/07/2014'</code> and it brings back the same result, it disregards the dates and brings back the entire database.</p>
  
  <p>I have a feeling that it is because the column is set to VARCHAR but I am not sure.</p>
  
  <p>If someone could point me in the right direction that would be most helpful.</p>
  
  <p>Thanks for taking the time to read this.</p>