title: SQL CASE Statement Change Column name in THEN clause
body: <p>Is there anyway that I can change column name through THEN clause in CASE STATEMENT. This is how my code looks but it is not working.</p>
  
  <pre><code> SELECT 
       CASE 
          WHEN @IDWeeklySpecial = '107' 
             THEN 
                CASE 
                   WHEN ISNULL(v.blnLeftHandDrive, 0) = 1 
                      THEN [HANDEDNESS] = 'LHD' 
                      ELSE [HANDEDNESS] = 'RHD' 
             ELSE 
                CASE 
                   WHEN ISNULL(v.blnLeftHandDrive, 0) = 1
                      THEN STEERING = 'LHD' 
                      ELSE STEERING = 'RHD' 
               END 
       END
  </code></pre>
  
  <p>I want this result</p>
  
  <p><a href="https://i.stack.imgur.com/8okJy.png" rel="nofollow noreferrer">My Ideal Result</a></p>
  
  <p>Is this achievable? If so how?</p>