title: sql query to update datetime field based on currentdate + value
body: <p>I have two fields in a table, one varchar field which is saving values such as 3, 4, 11 or NULL which translates to 3, 4 or 11 years.</p>
  
  <p>Recently I introduced new column in the same table of type date where I'm saving dates and which will eventually replace the previous field. </p>
  
  <p>These are the actual columns: </p>
  
  <p><a href="https://i.stack.imgur.com/Yskkt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Yskkt.png" alt="enter image description here"></a></p>
  
  <p>So for the new LeaseRemainingFirstBreakDate field I want to do GETDATE() + the value in the LeaseRemainingFirstBreak field if its not null.</p>