title: get array length after splitting string in sql server
body: <p>I would like to be able to split a string in SQL Server . I have a sample string</p>
  
  <pre><code>1012,1012,1012,1012,1012,1012,1012,1012
  </code></pre>
  
  <p>Here need length after splitting this string.</p>
  
  <pre><code>Expected output: 8
  </code></pre>