9 Replies Latest reply: May 15, 2016 1:35 PM by jagan mohan rao appala RSS

    how to use null in the IF condition

    pardha saradhi s

      Hi

       

      i have four  columns (A,B,C,D) in the same table  which contains zeros and null values in the A,B,C (tables) i need to replace only  null

      value in ABC columns from D column(any value)

       

      i think i need to use IF condition to replace the null values

       

       

       

      ABCD
      123221-321
      1242220322
      02230323
      126224-324
      127-234325
      0011326
      ---327
      -0-328

       

      Regards

      Pardhu