title: Get substring from varchar column in SQL server table
body: <p>I have one column called Name and in the column I have values  </p>
  
  <pre><code>Name
  001 BASI Distributor (EXAM)
  002 BASI Supplier (EXAM2)
  MASI DISTRIBUTOR (EXAM002)
  MASI SUPPLIER (EXAM003)
  EXAM_ND Distributor Success System Test (EXAM_ND)
  EXAM_SS Supplier Success System Test (EXAM_SS)
  </code></pre>
  
  <p>now I want to separate the value inside the <code>()</code> from this whole string.How I will get this I tried for the <code>SUBSTRING (Name ,22 ,4 )</code> but this will help for single one I want to get the result using some unique solution.</p>