title: Split string on only first occurance of character/delimiter
body: <p>I've been searching all morning for this.</p>
  
  <p>My knowledge of SQL Server is not excellent, and I'm out of answers.</p>
  
  <p>Concrete examples are: <code>City-Of-Style</code> or <code>Part1-Part2</code>.</p>
  
  <p>I need to split these examples into <code>City</code> and <code>Of-Style</code> and <code>Part1</code> and <code>Part2</code>.</p>
  
  <p>I figured out this little piece of code, but it switches part1 and part2 if the string contains a '-'.</p>
  
  <pre><code>PARSENAME(REPLACE('sample-string', '-', '.'), 1))
  </code></pre>
  
  <p>Any help on accomplishing this (preferably without a 200 lines function) is greatly appreciated.</p>