17 Replies Latest reply: Oct 20, 2009 12:06 PM by sanchez RSS

    transform Null value to value

      Got a problem. Want to give al empty values in the field costcenter the value 4000.

      My query won't work. What's wrong? I still got empty values with production on it.

      Load if(costcenter ='', '4000',costcenter) as costcenter1;
      sql select *
      from table1;

      sql select
      production,
      costcenter as costcenter1
      from table1;