title: SQL Server Remove multiple character strings within one string
body: <p>I have the following string of text in my database:</p>
  
  <pre><code>Value1 - Value2:  Value3 - Value4: Value5 - Value6: 
  </code></pre>
  
  <p>I need to remove the dash AND everything between the dash up until the colon</p>
  
  <p>The above result would become:</p>
  
  <pre><code>Value1: Value3: Value5:
  </code></pre>
  
  <p>Basicly, there could be endless amounts of values, but there could only be just a series of one.</p>
  
  <p>Thing to note: The values could be any string!</p>
  
  <p>Is there an easy way to do this? Preferably without a UDF. Could anyone help me out with this? Thanks in advance!</p>
  
  <p>Edit: I agree this is a very poor implementation. The rest of the database itself isnt like this at all. It's just one table. The query I get from this will be used in a view where all values are seperated into multiple aliases. Thanks for understanding</p>