if condition and not using match function to combine the fields

[#1]

Hi all,

I have some data

status   close_flag

closed            -1

>closed          -1

closed-app     -1

cancelled        -1

open                 0

completed        0

if(close_flag = -1,if((wild match('closed', '>closed', 'closed-app', 'cancelled'),'closed', status),status) I am using this condition to merge the all closed fields (close_ flag = -1)  into one common field is closed. this is the hardcoded code . only this  close_flag = -1 is correct the field  merge to the closed field how to merge  without using wild match, match functions .

is it possible plz tell me......urgent 

[MK_QSL]

IF(close_flag = -1, 'Close',status) as status

[MarcoWedel]

if(close_flag,'closed',status) as Closed

[MarcoWedel]

plz close thread......urgent

thanks

regards

Marco