9 Replies Latest reply: Oct 29, 2014 3:32 PM by Anand Chouhan RSS

    IF, IsNull

      Hi,

      Is this syntax is correct?

       

      DIM_PAYS :

      LOAD "PAY_CODE",

            IF (isnull("PAY_NOM"),PAY_NOM,'') AS 'Pays',

            "DEV_CODE";

      SQL SELECT PAY_CODE,

                 PAY_NOM,

                 DEV_CODE

      FROM ICP.dbo.PAYS;  

       

      Thanks

       

      Regards.