title: Is there a simple way to do hexadecimal arithmetic using sql server/TSQL?
body: <p>I have a column of hexadecimal values in a table. I want to add a hex value to all values in that table. If it were a simple int I would run something like this:</p>
  
  <pre><code>UPDATE myTable
  SET num = num + 4000
  </code></pre>
  
  <p>Is there any way to do this simply using hexadecimal arithmetic? Or do I have to convert the column value to decimal, convert the value I want to add to decimal, add them, and convert the value back to hex? (And if so, what's the simplest way to do that?)</p>
  
  <p>(NOTE: We are currently using sql server 2000.)</p>