UPDATE with more than one condition

[pradchal1]

I am trying to UPDATE a table and my syntax:

Update table1
Set
Name = "Held"
where Name_Hold = 'Yes'
OR
Set
Address = "Held"
where Address_Hold = 'Yes'
OR
Set Phone = "Held"
where Phone_Hold = 'Yes'



is not working.

Any help would be appreciated. Thanks

 

[SQLDenis]

Update table1
Set
Name = 'Held',Address = 'Held',Phone = 'Held'
where Name_Hold = 'Yes'
or Address_Hold = 'Yes'
or Phone_Hold = 'Yes'

http://sqlservercode.blogspot.com/

 

[gmmastros]

This syntax may work. Theoretically, if the Name_Hold is not 'y' then the value of the name field should be unchanged. I strongly suggest that you test this really well before putting it in to production.

Update Table1
Set    Name = Case When Name_Hold = 'Y' Then 'Held' Else Name End,
       Address = Case When Address_Hold = 'Y' Then 'Held' Else Address End,
       Phone = Case When Phone_Hold = 'Y' Then 'Held' Else Phone End

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[jbenson001]

Try

Update table1
Set Name = 'Held'
Where Name_hold = 'yes' OR
      Address_hold = 'Yes' OR
      Phone_hold = 'Yes'

 

[jbenson001]

Sorry, misread your post.. please ignor my code..
Jim

 

[vongrunt]

As a side note... what is wrong with three (3) separated UPDATEs?

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[gmmastros]

I should mention that my code differs from Denis's code. You should study both of them carfully and chose wisely.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[pradchal1]

Thanks for all your suugestion. But I figured out the easiest, clear and efficient would be to go with three Updates like Vongrunt suggested.

Thanks again to you all.