UPDATE QUERY QUESTION

I need to do a single update query with the following:

UPDATE sections SET PHASE = 'A' WHERE CONDUCTOR = '2-2, 2-2';
UPDATE sections SET PHASE = 'AB' WHERE CONDUCTOR = '2-3';
UPDATE sections SET PHASE = 'ABC' WHERE CONDUCTOR = '2-4';
UPDATE sections SET PHASE = 'ABC' WHERE CONDUCTOR = '4-2, 6-2';
UPDATE sections SET PHASE = 'ABC' WHERE CONDUCTOR = '4-2-, 6-2';
UPDATE sections SET PHASE = 'AB' WHERE CONDUCTOR = '4-3';
UPDATE sections SET PHASE = 'ABC' WHERE CONDUCTOR = '4/0-3, 2/0-1';
UPDATE sections SET PHASE = 'A' WHERE CONDUCTOR = '6-1, 4-1';
UPDATE sections SET PHASE = 'A' WHERE CONDUCTOR = '6-2';
UPDATE sections SET PHASE = 'ABC' WHERE CONDUCTOR = '6-2, 4-2';

I'm new to Oracle can anyone help me get this done with one query.

This is how I do it in ACCESS

UPDATE SECTIONS SET SECTIONS.PHASE =
IIf([conductor]="2-4","ABC",IIf([conductor]="4-2, 6-2","ABC",IIf([conductor]="4-3","ABC",IIf([conductor]="4/0-3, 2/0-","ABC",IIf([conductor]="6-1,
4-1","A",IIf([conductor]="6-2","A",IIf([conductor]="6-2, 4-2","ABC",[PHASE]))))))); I thought about decode would that work or is there something real simple that I am missing here. I apologize for my ignorance I'm very new to this program.
Thanks
-Jon Received on Fri Jan 28 2000 - 07:59:03 CST