Update tbl SET Case When Condition1 THEN Col1=1 When

cy163 · #1 (**permalink**) 04-24-09, 08:55

I want to do a Update operation to set a new value to Col1. the particular value is dependent on some conditions, Condition1 Condition2.....

I tried a query like the following command, but no luck.

[Code]
Update tbl
SET
Case When
Condition1
THEN Col1=1
When Condition2
THEN Col1=2
END;

I wonder if 'Case When' can only be used in SELECT clauses?

Thanks

r937 · #2 (**permalink**) 04-24-09, 09:49

Code:

UPDATE tbl  
   SET Col1 = CASE WHEN Condition1 
                   THEN 1 
                   ELSE 2 END
 WHERE Condition1 OR Condition2

don't forget the WHERE clause

Internet Services

Web Development

Digital Marketing

Consumer Tech