3 Replies Latest reply: Aug 31, 2014 7:15 AM by UPALI WIJERATNE RSS

    If Condition

    UPALI WIJERATNE

      IF(ISNULL(TYPE)=0,'NOT_LEGAL',ELSE,'LEAGL')AS CATEGERY

       

      I have written above code in my script. But It is not working. Can some correct it for me please.

      My requirement is if  TYPE is null then the  category   should be 'NOT LEGAL' else 'LEGAL'