9 Replies Latest reply: Sep 22, 2015 1:42 AM by Marco Wedel RSS

    Where Statement Syntax

    Mark Rudolphi

      I want to exclude data from my data load.  I know I can use as example: Where field <> 'name'.

       

      What I would like to do is exclude data when two different fields have specific names.  Can I use And?  Is this the correct syntax?

       

      Where field1 <> 'name1' and field2 <> 'name2'