Adding or Substractint to a current value

[kikeman]

Hi,

I have a table with a column "Hrs" that is a double type.

I would like to add or substract hours to the current value with a single UPDATE command. i.e:

Orders Hrs
Q6E4D3 2.5

I would need to add 3.5 hrs:

Orders Hrs
Q6E4D3 6.0

What would be the SQL UPDATE command to do this?

Thanks,
kikeman.

 

[jal]

UPDATE Table1 SET Hrs = Hrs + 3.5 WHERE ORDERS = 'Q6E4D3'