3 Replies Latest reply: Dec 9, 2016 9:33 AM by Sunny Talwar RSS

    Add value to NULL

    Sebastian Fagerlund


      I have two tables that are linked by one key and i want to add a value to null's..

      I have tired:



         if (isnull([field]) or field='',1,0) as test2,

         if(len(trim(field))=0,'0','field') as test,

         istext(field) as test3,

         isnum(field) as test4,

      i have also tried:

          SET NullValue='Missing';

         NullAsValue *;

      Screenshot 2016-12-09 15.22.27.png


      But it dosen't work. What els could i try?