UPDATE syntax problem

[rjbutler]

Sorry but I'm a bit of a SQL novice and having trouble setting a bit value based on other numeric column values.
What I want to do is somthing like this (in pseudo speak!)

UPDATE MyTable
SET MyBitColumn = ((MyNumeric1 > 0 ) OR (MyNumeric2 >0))
WHERE etc.

What is the correct sysntax to evaluate the logic expression?

Many thanks!

 

[rjbutler]

Sorry!
More specifically I need:

UPDATE MyTable
SET MyBitColumn = ((MyNumericColumn1 + MyNumericColumn2) <> 0 )
WHERE etc.

Thanks.

 

[bcking]

Give this a go.

UPDATE MyTable
SET MyBitColumn = MyNumericColumn1 + MyNumericColumn2
WHERE MyNumericColumn1 + MyNumericColumn2 <> 0
and etc....

Brett

 

[swampBoogie]

I don't see why you need to store redundant data. Calculate it when you need it.

select case when MyNumericColumn1 + MyNumericColumn2) <> 0 
  then 1 else 0 end as q
from t

 

[rjbutler]

Thanks guys - got it working now.