title: No functions, no Split_String. Use XML to split string into different fields by delimiter
body: <p>I have a string like this that doesn't have a consistent format and needs to be broken into fields by the ':' delimiter</p>
  
  <pre><code>  1:35410:102001001:102001:10:1
  </code></pre>
  
  <p>'STRING_SPLIT' is not a recognized built-in function name in my version of SQL Server</p>
  
  <p>Any other suggestions? Thanks in advance!</p>