title: How to get the 1st value before delimiter in sql server
body: <p>In one of the column i am getting 2 values with a delimiter between it
  How to extract both the values </p>
  
  <p>I have some thing like this Column <code>TRN02</code> is <code>115679-5757</code></p>
  
  <p>I need to take values before delimiter and after delimter into 2 separate columns again.</p>
  
  <p>Can some one help me on this</p>