title: Split a string to only use the middle part in SQL
body: <p>I have a string</p>
  
  <pre><code>ABC - ABCDEFGHIJK - 05/07/2016
  </code></pre>
  
  <p>I want to only use the <code>ABCDEFGHIJK</code> section and remove the first and third parts of the string.</p>
  
  <p>I have tried using <code>SUBSTRING</code> with <code>CHARINDEX</code>, but was only able to remove the first part of the string.</p>
  
  <p>Anyone help with this?</p>