title: SQL Server : SELECT * FROM [dbo].[Table] WHERE
body: <p>I'm new to SQL Server, and I'm trying to select a range between two dates.</p>
  
  <p>My column is <code>varchar</code> (format: <code>dd.mm.yyyy hh:mm:ss</code>), but if I use </p>
  
  <pre><code>SELECT * 
  FROM [dbo].[Table] 
  WHERE [Column] BETWEEN 'lower date' AND 'max date'
  </code></pre>
  
  <p>the result is every date that begins with the first two search option. In my case "dd" <em>(dd.mm.yyyy hh:mm:ss)</em>. </p>
  
  <p>Is there a solution, without changing the column from <code>varchar</code> to <code>datetime</code>?</p>