Update with conditional variable 1

[anrver]

I'm updating a column as follows :

UPDATE table
SET Office = 'ANR'
WHERE Department = 'SE'
GO
UPDATE table
SET Office = 'BRU'
WHERE Department = 'AI'

Is there a way I can do this in one run ? I was thinking about setting a variable depending on the 'Department' value and updating the column with this variable.



Erik Verstichel
Panalpina World Transport.
Antwerp, Belgium

 

[edwinjs]

UPDATE table
SET Office = CASE WHEN Department = 'SE' THEN 'ANR' ELSE 'BRU' END
WHERE Department in ('SE','AI')