title: How to truncate string using SQL server
body: <p>i have large string in SQL Server. I want to truncate that string to 10 or 15 character</p>
  
  <p>Original string</p>
  
  <pre><code>this is test string. this is test string. this is test string. this is test string.
  </code></pre>
  
  <p>Desired string</p>
  
  <pre><code>this is test string. this is ......
  </code></pre>