1 Reply Latest reply: May 27, 2015 3:29 AM by Robert Mika RSS

    NULL vs SPACE

    Łukasz Liziniewicz

      Hello, I would like to create column in loading script base on the source column. My new column should be a flag:

       

      if (isnull(SOURCE), 1, 0)

       

      The problem is that in source data sometimes I have null but sometimes it is space or even several spaces. I tried with TRIM function:

      if(isnull(trim(SOURCE)), 1, 0)

      but it did not work.

       

      Could you help me please?