title: SQL Case statement combine two fields together?
body: <p>I have a question about CASE statement. My case statement looks like this: </p>
  
  <pre><code>CASE myField1
          WHEN 1 THEN 'Jump'
          WHEN 2 THEN 'Sleep'
          WHEN 3 THEN 'Eat'
          WHEN 4 THEN 'Run'
          WHEN 5 THEN 'Break'
          WHEN 6 THEN 'Move'
          WHEN 7 THEN 'Stop'
          ELSE NULL END AS TestColumn,
  </code></pre>
  
  <p>On this statement I have to add one more initial based on the value from other field. So on the end of each WHEN options there might be a letter A if myField2 is equal to 1. If not then I will not put the letter A. Output should be something like this: </p>
  
  <pre><code>Jump A
  Sleep
  Eat A
  Run
  Break
  Move A
  Stop
  </code></pre>
  
  <p>How I can check for my second field in SQL CASE and concat the value on existing words? If anyone can help please let me know. Thanks!</p>