title: SQL Server : use LIKE inside a CASE statement to replace characters in string
body: <p>Apologies for poorly worded question.</p>
  
  <p>I have the following column <code>description</code> with contents like:</p>
  
  <pre><code>2511420s5
  38114CR
  2510014IND
  </code></pre>
  
  <p>I want to get rid of the <code>s5</code>,<code>CR</code>and <code>IND</code>using a <code>CASE</code> statement.</p>
  
  <p>Something like:</p>
  
  <pre><code>select 
      CASE 
         WHEN description LIKE ('%CRT%', '%IND%', '%MR%') THEN ''
         ELSE description
      END as test 
  from table
  </code></pre>
  
  <p>So to summarize, I want to strip the <code>S5</code> from my string if it exists.</p>
  
  <p>I have a list of about 15 possibilities so don't want to use a nested replace statement. </p>
  
  <p>Can this be done with <code>CASE</code> or is there a better option?</p>
  
  <p>Thanks,</p>