title: string ( dd/mm/yyyy) to date sql server
body: <p><strong>EDIT</strong>: 
  The solution is in the reference post's solution .I was careless to overlook DATETIME--> Varchar(10)</p>
  
  <p>`Syntax for CONVERT:</p>
  
  <pre><code>CONVERT ( data_type [ ( length ) ] , expression [ , style ] )`
  </code></pre>
  
  <p>I am aware of <a href="https://stackoverflow.com/questions/207190/sql-server-string-to-date-conversion">this</a> post</p>
  
  <blockquote>
    <p>SQL Server (2005, 2000, 7.0) does not have any flexible, or even non-flexible, way of taking an arbitrarily structured datetime in string format and converting it to the datetime data type.</p>
  </blockquote>
  
  <p>So I am looking for a solution that solves this particular String format only.</p>
  
  <p>Let's say I have a table in sql server with field :<code>inputDate</code> in <code>datetime</code> format</p>
  
  <p>The following code works without convert/cast </p>
  
  <pre><code>SELECT inputDate
  FROM   some_table
  WHERE  inputDate &gt; '01/24/2013' 
  </code></pre>
  
  <p>But it won't work for </p>
  
  <pre><code>SELECT inputDate
  FROM   some_table
  WHERE  inputDate &gt; '24/01/2013'
  </code></pre>
  
  <p>Throwing an <code>The conversion of a varchar data type to a datetime data type resulted in an out-of-range value</code></p>
  
  <p>Then I tried </p>
  
  <pre><code>SELECT inputDate
  FROM   some_table
  WHERE  inputDate &gt; CONVERT(VARCHAR(10), '24/01/2013', 103)
  </code></pre>
  
  <p>Throwing the same error </p>
  
  <p>Is there a way to <strong>convert string in dd/mm/yyyy to be recognize as datetime format</strong> in SQL SERVER? Or the only way, and the proper way is doing santization elsewhere?</p>