4 Replies Latest reply: Apr 4, 2014 11:50 AM by Elizabeth Kincses RSS

    IF Match

      Hello ,

       

      Can you please point me to the right direction?

      I am trying to run below script;

       

      LOAD CATALOG,

      IF (match(KITCHEN,BEDROOM, KITCHEN1, KITCHEN2, BEDROOM1));

       

      SQL SELECT *

      FROM database.dbo."database_name"

      WHERE STATUS<>'XX'

       

      not working, the error message is;

      Error in expression:

      If takes 2-3 parameters

       

      What I am doing wrong?

       

      Thank you in advance, all little helps :-)