Need idea to write this code better

[Former Member]

HI,

there is better way to write this code?

IF poss = '1'.

DELETE col_c WHERE sta_act = ' '.

ELSEIF poss = '2'.

DELETE col_c WHERE sta_act = 'X'.

ELSEIF poss = '0'.

ENDIF.

Regards

[Former Member]

HI,

there is better way to write this code?

IF poss = '1'.

DELETE col_c WHERE sta_act = ' '.

ELSEIF poss = '2'.

DELETE col_c WHERE sta_act = 'X'.

ELSEIF poss = '0'.

ENDIF.

Regards

[Former Member]

Use a CASE Statement

[Former Member]

hi ,

use this.

case poss.

when '0'.

when '1'.

DELETE col_c WHERE sta_act = ' '.

when '2'.

DELETE col_c WHERE sta_act = 'X'.

endcase.

regards,

venkat.