title: SQL, extract integer before and after '-' of a string
body: <p>I have a column with these values</p>
  
  <pre><code>row 1 Spare Part ##:      **704604-001** part 
  row 2 Spare Part #:   **511778-001** 
  row 3 part number, a list of common parts follows...**439730-001**)Part number Description   
  
  row 4 Spare Part:     **774172-001**&amp;#x0D;Memory Board Nu
  row 5 Spare Part:**639852-001**
  </code></pre>
  
  <p>I want to extract only the xxxxxx-001 out of the string.
  example result:</p>
  
  <pre><code>704604-001
  511778-001
  439730-001
  774172-001
  </code></pre>
  
  <p>Anyone can help me?</p>
  
  <p>SQL 2012</p>