title: SQL Server - date comparison
body: <pre><code>SELECT 
     CASE WHEN '04/10/2006' &lt; '07/01/2013' THEN 'TRUE' ELSE 'FALSE'
  END
  </code></pre>
  
  <p>Output: TRUE</p>
  
  <pre><code>SELECT
     CASE WHEN '10/31/2006' &gt; '07/01/2012' THEN 'TRUE' ELSE 'FALSE' 
  END
  </code></pre>
  
  <p>Output: TRUE</p>
  
  <p>This is so confusing. I executed these two query and I got o/p as true for both the queries. The o/p to 1st query is correct. Shouldn't the output to 2nd query be false.? Can someone help please?</p>