Re: can sql CASE handle multiple column updates in a CASE statement?

Joel

I'd give a provisional "yes" - all CASE does is say which stuff goes into the final SQL statement - it is often used to change what the ORDER BY is that will be executed.

I think you can think of the stuff in the WHEN's as just character strings of which only one is used - perhaps on a row-by-row basis.

HTH
Vern

On 5/8/2014 11:25 AM, Stone, Joel wrote:

update jstone/docs00
case doctype2
when 'HEDGECONFIRMS'
set KEYWORD5 = KEYWORD1,
KEYWORD9 = KEYWORD2,
KEYWORD8 = KEYWORD3,
KEYWORD1 = ' ',
KEYWORD2 = ' ',
KEYWORD3 = ' '
when 'CONTRACTFORM'
when 'AMENDMENTFORM'




Or must I use many CASE statements to do this?

Thanks!

______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________