title: How to split string into multiple in sql server
body: <p>I'm Having a column data like below,</p>
  
  <pre><code>126-35-56-24
  </code></pre>
  
  <p>And I want the results be like,</p>
  
  <pre><code>select 126 as Id, 35 as Age, 56 as EmpId, 24 as Day
  </code></pre>
  
  <p>I just try using <code>substring</code> and I can Able to split the string into 126 and 35-56-24, but I can't get the result I Want.</p>
  
  <p>Please help me to get this. Thanks in Advance...</p>