title: SQL query to ADD new column in table with condition
body: <p>I want to add the new column with the condition that if the value of 1st columns is diff. then 2nd columns then only it will be alter with condition OR else the value remain same.</p>
  
  <p><a href="https://i.stack.imgur.com/qAsy3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qAsy3.png" alt="enter image description here"></a></p>
  
  <p>The Above image will clarify my requirement more effectively. </p>
  
  <p>Below query only alter the column but please guide how to apply condition in the same.</p>
  
  <pre><code>ALTER TABLE Wealth_CFY ADD Type3 AS (Type1 + ' ' + Type2)
  </code></pre>