title: how to get 2 words with SUBSTRING in SQL SERVER
body: <p>i have a column containing like this</p>
  
  <pre><code>Term
  ------- 
  Semester Genap 2016/2017 
  Semester Ganjil 2016/2017
  </code></pre>
  
  <p>i want to get</p>
  
  <pre><code>Term
  ------- 
  Semester Genap 
  Semester Ganjil
  </code></pre>
  
  <p>how to do it with SUBSTRING?</p>