title: Teradata String Manipulation (Second Space)
body: <p>I'm having great difficulty solving this seemingly easy task:</p>
  
  <p>Purpose:
  Create a query that eliminates the middle Initial</p>
  
  <p>Example</p>
  
  <pre><code>Name
  Smith, John A
  Jane, Mary S
  </code></pre>
  
  <p>I would like an output such as this:</p>
  
  <pre><code>Name
  Smith, John
  Jane, Mary
  </code></pre>
  
  <p>Any tips on how to do this with Teradata SQL</p>
  
  <p>I believe I solved the issue, albeit in a very poor way:</p>
  
  <pre><code>SELECT SUBSTR('SMITH, JOHN A', 0, (POSITION(' ' IN 'SMITH, JOHN A') + (POSITION(' ' IN SUBSTR('SMITH, JOHN A',(POSITION(' ' IN 'SMITH, JOHN A'))+ 1,50)))))
  </code></pre>