title: Fetch string from dashed string in SQL Server
body: <p>I have a table which contains dashed strings. </p>
  
  <p>I want string between last dash and second last dash</p>
  
  <p>Dash means <code>-</code></p>
  
  <p>SQL Server table</p>
  
  <pre><code>Create table tbl1 (vdocno varchar(200))
  
  insert into tbl1 values('Abcd-67-Hji-kok-74-Kio')
  insert into tbl1 values('Bki-6kdi7-jhfi-Hfjdji-koikk-7ji4-Kloio')
  </code></pre>
  
  <p>Desired output values:</p>
  
  <pre><code>74
  7ji4
  </code></pre>
  
  <p><a href="http://www.sqlfiddle.com/#!6/f5569" rel="nofollow">SQLFIDDLE</a></p>