title: SQL Statement for removing letters from column values after special character
body: <p>I have a Table named "TableA" and there is column " KNumber" and that column has some values [Data] which contain Pipe ' | ' in.</p>
  
  <p>For example as below.</p>
  
  <pre><code>1. AMERIK20121218|HA
  
  2. AMERIKINITIAL20121130|DSS
  
  3. |DSS
  
  4. |HI
  </code></pre>
  
  <p>Now I want to perform clean up on that "TableA" by removing these extra values in KNumber column- If there is an ' | ' at</p>
  
  <p>the end and any value after ' | ', that need to be removed.  </p>
  
  <p>What would be the TSQL query to perform this operation? 
  I have like 3000 rows for that column which have ' | ' in it. I want to update all these 3000 rows and remove whatever it is after that '|'. </p>
  
  <p>I use SQL Server 2008 R2. </p>
  
  <p>Thanks in advance for help. </p>