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'