title: Validate DateTime String in SQL Server 2005
body: <p>I require a SQL script to validate a VARCHAR field in a table in a SQL Server 2005 database that contains DateTime values, in the format <code>DD/MM/YYYY</code>, or <code>NULL</code> values.  I would like to identify all invalid dates.  Can anyone suggest a method?</p>
  
  <p><strong>UPDATE</strong></p>
  
  <ul>
  <li>The answer has to make use of T-SQL; for performance reasons, I can't make use of SQLCLR.</li>
  </ul>
  
  <p>Thanks, MagicAndi</p>