title: Delimiting results in SQL Server 2012
body: <p>I'm trying to extract data from a column <code>PRODUCT_ID</code> which contains values like</p>
  
  <pre><code>101-1*S5-04004PC0
  13-4*1.01.11
  </code></pre>
  
  <p>I want to get these values in two separate columns, delimited by <code>*</code>. Can someone please help?</p>
  
  <pre><code>select PRODUCT_ID 
  from TABLE1;
  </code></pre>
  
  <p>I also have some data like this 101-1*S5-04004PC0*123 (meaning having two delimiters) but i just want the query to separate it when it finds the first * from left.</p>