4 Replies Latest reply: Jan 31, 2012 8:21 PM by Johannes Sunden RSS

    Resident load where field is not null

    Matthew Green

      Hi,

       

      I'm trying to restrict a resident load to where a particular field is null.

       

      I've tried

       

      RESIDENT TableName
      WHERE NOT FieldToCheck IS NULL;
      
      

       

      But this didn't work.

       

      I can't do the restriction in the sql load statement, since I need the cases where the field is null to be present in another resident load.

       

      Any help would be appreciated.