4 Replies Latest reply: Mar 20, 2013 2:19 AM by jagan mohan rao appala RSS

    If statement with multiple conditions?

      I'm trying to develop an If statement that matches several conditions.  The reason I am trying to do this is to remove some data that isn't necessary.

       

      We often have people testing inside our database.  They'll use a User ID like "ed_t" or "D_ET".  So I when I import my data, I don't want to include those in the dataset at all.

       

      My If statement doesn't seem to work, though.  It only matches the first condition.  Any thoughts?

       

      If(left(lower([User ID]), 3) <> 'ed_t' or 'D_ET', 1) as [Exclude User ID]