title: SQL Server - string separation with length cutoff
body: <p>So I have a string that is from search and it can contain multiple words I want to cutoff the words at 10 characters i.e.</p>
  
  <pre><code>DECLARE @SearchString varchar(255) = 'Administration Duplication'
  </code></pre>
  
  <p>becomes: <code>'Administra Duplicatio'</code></p>