Re: [SQL] Conditional expression in an UPDATE statement

2013-02-06 Thread Jasen Betts
On 2013-02-07, JORGE MALDONADO wrote: > Can I use a conditional expression in an UPDATE query like this: > > UPDATE table_1 SET > field_1 = > CASE WHEN (condition) THEN (COALESCE(query_1, -1)) > ELSE (COALESCE(query_1, -2)) > END > yesh, that should work. -- ⚂⚃ 100% natural -- Se

[SQL] Conditional expression in an UPDATE statement

2013-02-06 Thread JORGE MALDONADO
Can I use a conditional expression in an UPDATE query like this: UPDATE table_1 SET field_1 = CASE WHEN (condition) THEN (COALESCE(query_1, -1)) ELSE (COALESCE(query_1, -2)) END With respect, Jorge Maldonado