5 Replies Latest reply: Nov 4, 2013 12:46 PM by Arturo Javier Torres RSS

    Where Field is Null not working

      hello,

       

      I have a table with articles, and each article has a code. this code is stored in another column.

       

      ArticlesCode
      Article 112345
      Article 1
      Article 1
      Article 22345
      Article 2

       

      I try to only select the fields that have a code, but somehow I cannot select Null.

       

      I tried this:

       

      [FactuurNummerLeverancierTemp]:
      LOAD
        invs1_ref as [DocumentNumber],
        invscs_order_no as [FactuurNummerLeverancier];
      SQL SELECT * FROM INVS_DATA
      WHERE INVS1_CO_SITE = '01'
        AND invscs_order_no IS NOT NULL
            AND INVS1_REC_TYPE = 2;
      

       

      Not working.

       

      I also tried len() > 0 in a resident load. nope

       

      Please help.