1 Reply Latest reply: Dec 15, 2016 6:53 AM by Gysbert Wassenaar RSS

    Evaluate NULL values in a filed

    Aniruddhya Dutta

      Hi All,

       

      I want to evaluate if a filed is NULL or not in a table and based on which I  want to assign a status in another filed in the table(like a flag)

       

      //if (EVENT_COMMENT='-' ,'ACTIVE','HANDLED') as FINAL_ALERT_STATUS

          //if(len(trim("EVENT_COMMENT"))='0','ACTIVE','HANDLED') as FINAL_ALERT_STATUS

          //if(ISNULL(EVENT_COMMENT),1,0) as FINAL_ALERT_STATUS

           if(len(trim(EVENT_COMMENT))=0,'ani') as FINAL_ALERT_STATUS

       

      I tried all the above options but nothing seems to work.Can someone plz help on this?