title: Deleting certain pieces of values in between delimiters- SQL server
body: <p>What I am trying to do is delete certain data from an email column.  </p>
  
  <p>Every email with <code>@w.com</code>, <code>@x.com</code>, <code>@y.com</code>, and <code>@z.com</code> must be deleted from the emails</p>
  
  <p>The problem I have is that there are more than one emails in each row for the email column, these email addresses are separated like </p>
  
  <pre><code>john@daddsa.com; johnsemail@aadsss.com; johnmainemail@z.com; johnthrowemail@y.com 
  </code></pre>
  
  <p>(using the semicolon <code>;</code> as a delimiter)</p>
  
  <p>There are many rows that contain the email addresses I am trying to delete. The email column is <code>vch</code>. </p>
  
  <p>All email addresses vary in length. </p>
  
  <p>I'm guessing this is done by running some sort of loop.</p>
  
  <p>Thank you in advance.</p>