title: Split string in SQL Server to a maximum length, returning each as a row
body: <p>Is there a way to split a string (from a specific column) to n-number chars without breaking words,   with each result in its own row?</p>
  
  <p>Example: </p>
  
  <pre><code>2012-04-24 Change request #3 for the contract per terms and conditions and per John Smith in the PSO department  Customer states terms should be Net 60 not Net 30.  Please review signed contract for this information.
  </code></pre>
  
  <p>Results:</p>
  
  <pre><code>2012-04-24 Change request #3 for the contract per terms and conditions and per John Smith in the
  PSO department  Customer states terms should be Net 60 not Net 30.
  Please review signed contract for this information.
  </code></pre>
  
  <p>I know I can use <code>charindex</code> to find the last space, but im not sure how i can get the remaining ones and return them as rows.</p>