title: How to use split a string and get all the values in array in sql server 2005
body: <p>I am searching for a code that helps me let the same thing done as c# or c++ code.
  Which is </p>
  
  <pre><code>string[] array = new string[5];
  array = newstring.split(',');
  </code></pre>
  
  <p>The new <code>array</code> get stored all values one by one and i can loop through them sequentially.</p>
  
  <p>Any one knows the answer please help me out?</p>