title: SQL parse string into fields
body: <p>I have a string <code>firstname.lastname@domain.com</code> and I would like to parse the string into 3 columns.</p>
  
  <ul>
  <li>column 1 - firstname</li>
  <li>column 2 - lastname</li>
  <li>column 3 - domain.com</li>
  </ul>
  
  <p>I've tried several variations of using <code>RTRIM</code>, <code>SUBSTR</code> and <code>REGEXP_SUBSTR</code> with no success.  Any assistance would be helpful.</p>