title: Using CASE in Teradata, but only change some values
body: <p>I have a variable in my database that I want to change name on with CASE - WHEN-THEN but I want the variable to keep the values if the WHEN statement does not match.
  How I wrote it:</p>
  
  <pre><code>(CASE 
  WHEN Variable_name EQ ANY ('AA','AB','AC') then 'AA'
  END) 
  </code></pre>
  
  <p>I want my other results in Variable_name to be what they already is.
  My data looks something like this:</p>
  
  <pre><code>Variable_name   Count
  AA              2
  AB              1
  AC              5
  BA              7
  CA              5
  </code></pre>
  
  <p>And I want it to look like:</p>
  
  <pre><code>Variable_name   Count
  AA              8
  BA              7
  CA              5
  </code></pre>