title: T-SQL select sum of Two integer column
body: <p>I have two columns Val1 and Val2 as int in SQL Server 2008
  When I select Tot = Val1+Val2 from Table, I get null as Tot</p>
  
  <p>How do I get total of two int columns selected?</p>
  
  <p>Many thanks.</p>