title: string to date conversion issue SQL
body: <p>I am having an issue with the conversion below:
  I am using two main tables client and cli-identifier(this holds the information column)</p>
  
  <p>I have a column in cli-identifier table called information currently holding dates in two ways (only thing changing is the date value):</p>
  
  <pre><code>First: 22/11/16 * Company info A/C
  Second: 22/11/2016 * Company info A/C
  </code></pre>
  
  <p>I use the following query to slice the information out of the column:</p>
  
  <pre><code> left(Substring(ci.information, charindex('[0-9]',ci.information),103)
       ,charindex('*',ci.information + '*')-2) as datereceived
  </code></pre>
  
  <p>After which I am receving the follow strings:
  <a href="https://i.stack.imgur.com/xgOPk.png" rel="nofollow noreferrer">example of the two different types showing</a></p>
  
  <pre><code>22/11/16
  22/11/2016
  </code></pre>
  
  <p>I require these converted date/time or just date but unable to do so with the following code (I have also tried using cast to do this too):</p>
  
  <pre><code>convert(date,left(Substring(ci.information, charindex('[0-9]',ci.information),103),
   charindex('*',ci.information + '*')-2),1) as datereceived
  </code></pre>
  
  <p>Other methods I have tried is to convert this into a temp table and then using the following to cast the date.</p>
  
  <pre><code>select 
   cast (t AS date()
   from #a
  </code></pre>
  
  <p>I know the confliction lies in the date value being formatted as 22/11/<strong>16</strong> any input would be helpful.  Only solution I think of is adding to a temp table and making a query to insert the '20' value infront of the  22/11/<strong>16</strong> year.</p>