title: sql server all characters to right of first hyphen
body: <p>In SQL Server 2014, how can I extract all characters to the right of the first hyphen in a field where the first hyphen will have many combinations following it.</p>
  
  <p>example 1:</p>
  
  <blockquote>
    <p>Aegean-1GB-7days-COMP</p>
  </blockquote>
  
  <p>desired result:</p>
  
  <blockquote>
    <p>1GB-7days-COMP</p>
  </blockquote>
  
  <p>example 2:</p>
  
  <blockquote>
    <p>Aegean-SchooliesSpecial-7GB</p>
  </blockquote>
  
  <p>desired result:</p>
  
  <blockquote>
    <p>SchooliesSpecial-7GB</p>
  </blockquote>
  
  <p>example 3:</p>
  
  <p>AkCityOaks-1Day-3GB</p>
  
  <p>desired result:</p>
  
  <p>1Day-3GB</p>