title: SQL Server: Extract date from a description column
body: <p>how can I extract the dates from a description column (nvarchar) like these ones:</p>
  
  <pre><code>'LICENCE SUSPENDED UNTIL DEC 17, 2016 - ABILITY IMPAIRED SUSPENSION NO 5176283'
  'SUSPENDED FOR MEDICAL REASONS UNTIL JUNE 19, 2017'
  </code></pre>
  
  <p>The objective is to insert that date into a datetime column.</p>
  
  <p>I'm using SQL Server v17</p>
  
  <p>Thanks in advance :)</p>
  
  <p>edit:  there is always an 'UNTIL' before the unstructured date.</p>