title: How do I only return part of a string with varying lengths in SQL?
body: <p>I have a table with only 1 column that contains a string.  I am trying to only get the email address.  How can I do that?  I looked at Substring/Ltrim, etc, but I haven't been able to piece together how to extract only part of the string.  I am fairly new to SQL.  Thank you for your help!</p>
  <pre><code>Column1:
  
  John Smith     Email: John.Smith@987456email.com  Terminate:
    
  Jacqueline Smith    Email: Jacqueline.Smith@987456email.com     Terminate:
  </code></pre>