title: SQL Server replace, remove all after certain character
body: <p>My data looks like</p>
  
  <pre><code>ID    MyText
  1     some text; some more text
  2     text again; even more text
  </code></pre>
  
  <p>How can I update MyText to drop everything after the semi-colon and including the semi colon, so I'm left with the following:</p>
  
  <pre><code>ID    MyText
  1     some text
  2     text again
  </code></pre>
  
  <p>I've looked at <a href="http://msdn.microsoft.com/en-us/library/ms186862.aspx" rel="noreferrer">SQL Server Replace</a>, but can't think of a viable way of checking for the ";"</p>