5 Replies Latest reply: Apr 12, 2012 3:02 AM by Reynald Liandra RSS

    If(IsNull not working

    Göran Hofstedt

      Hi

      I have this in my script and it should set a 1 to the fields that are blank:

      If(IsNull(VERKVECKPER),1,VERKVECKPER) as VERKVECKPER,  

       

       

      I use a smiliar  If(IsNull(JCount),1,JCount) AS JCount, in another place and that works well. Anyone that noes way the first don`t?

      As seen in below image the NewField should be 3 if the IF IsNull would work.

      qv1.JPG