if else conditions in query

[Madhusri]

Hi Team,

Current table

column	row1	row2
status	failure	success

My Requirement-

1------if the row 1 has value as failure and if row 2 itself itself does not exists then row1 has to be renamed to failure

2------if the row 1 has value as success and if row 2 itself itself does not exists then row1 has to be renamed to success

3------if the row 1 has value as success and if row 2 has the value as failure ,then row 1 wants to renamed to as success and row 2 as failure.

4------if the row 1 has value as failure and if row 2 has the value as success, then row 1 wants to renamed to as failure and row 2 as success.

All these cases need in single query.

Can anyone help on this?

Regards,

Madhu R

[ITWhisperer]

Does you "table" have 3 columns, one called column, one called row1, and one called row2, and one row with the values status, failure and success respectively, or one column called status with two rows, one with failure and the other with success?

What do you want to happen if both are success?

What do you mean by rename? Is this change the value in the field or rename the field/ column?