title: SQL Server Remove Last Word
body: <p>I have variables in a column named Tier. Please see below some examples;</p>
  
  <pre><code>Tier  
  Tier 1 (Unspecified)
  Tier 7 (Anti-client)
  Tier 3 (Priority)
  </code></pre>
  
  <p>I would like the variables to be transformed like the below;</p>
  
  <pre><code>Tier  
  Tier 1
  Tier 7
  Tier 3
  </code></pre>
  
  <p>Would you know how to efficiently remove all the strings in brackets at the end of the variables?</p>
  
  <p>Thanks</p>
  
  <p>Chris</p>