4 Replies Latest reply: Jul 7, 2015 3:55 PM by Mark Graham RSS

    Where statement with Match,  not match, and not Wildmatch

    Mark Graham

      Hi Everyone,

       

      I'm trying on the Where statement below: But getting an error ") Expected"

       

      (Name='ABC' and Match(Department,'B') and  not WildMatch(Region, B*, C*, D*, F*, H*, J*, L*, M*, O*, P*, Q*, R*) and not Match(Region, SBB, STS, UPU, PSI))


      fetch the details of ABC, where department is B.

      Donot include the regions starting with B, C, D, F, H, J, L, M, O, P, Q, R.

      Donot include the regions SBB, STS, UPU, PSI.


      Please lemme know whether i'm on the right track.


      Help pls.