title: SQL Server : how to update and replace with wildcards
body: <p>How exactly do I replace something by using wildcard characters?</p>
  
  <p>I had tried with this but it doesn't work</p>
  
  <pre><code>UPDATE [dbo].[test]
  SET [Fælge] = REPLACE([Fælge],'%ET%%%','')
  </code></pre>
  
  <p>I want all the ET** to be blank </p>
  
  <p>My data looks like this and it goes from 4-12x10-24 ET0-99 plus a half like(4.5x13 ET35.5)</p>
  
  <pre><code>6x15 ET0|6.5x16 ET55|6x16 ET50|7x17 ET60|7x17 ET65
  </code></pre>
  
  <p>my data grouped and counted
  <a href="https://i.stack.imgur.com/xLD07.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xLD07.png" alt="my data grouped"></a></p>
  
  <p>i want both ET and the numbers to be blank so the data just looks like</p>
  
  <pre><code>6x15 |6.5x16 |6x16 |7x17 |7x17
  </code></pre>