title: Update column by parsing another column with T-SQL
body: <p>I have this table and data in my database:</p>
  
  <p><strong>tblPhotos</strong></p>
  
  <pre><code>ID | Title | Description
  ------------------------------
  1 | NULL | Some data - Title 123 - Subtitle - Photographer: John Doe
  2 | NULL | Some data - Photographer: Jane Doe
  3 | NULL | Some data - Title 345 - Photographer: John Doe Jr
  </code></pre>
  
  <p>The data in the <code>Description</code> column comes in two formats:</p>
  
  <pre><code>{GARBAGE DATA} - {TITLE DATA} - Photographer: ..., or
  {GARBAGE DATA} - Photographer: ...
  </code></pre>
  
  <p>Basically, I have thousands of rows, where the <code>Title</code> column is empty. I need to somehow pull it out of the <code>Description</code> column.</p>
  
  <p>The <code>Title</code> exists between the first dash and the and the last dash of the <code>Description</code> column. Here's what the data should look like:</p>
  
  <p><strong>tblPhotos</strong></p>
  
  <pre><code>ID | Title                | Description
  -------------------------------------------------------------------------------------
   1 | Title 123 - Subtitle | Some data - Title 123 - Subtitle - Photographer: John Doe
   2 | NULL                 | Some data - Photographer: Jane Doe
   3 | Title 345            | Some data - Title 345 - Photographer: John Doe Jr
  </code></pre>
  
  <p>How can I make a script that will parse a column, and update another column with that parsed data?</p>