6 Replies Latest reply: Nov 2, 2015 3:28 PM by Alec Smith RSS

    Where Not WildMatch Not Working

    Alec Smith

      Hello,

       

      I have a load script below that I need to not include all names that start with 'ACCT' in the FirstName field.  The where clause below is not working and is failing the load script (see attached screen shot).

       

      The where clause looks right based on multiple posts on this topic in the Community.  I'm not seeing where the issue is.  Has anyone dealt with this issue? 

       

      Thank you in advance for any assistance.

       

      Contacts:

      LOAD LastName,

          FirstName,

          CompanyName,

          Telephone1,

          Telephone2,

          Email,

        AddressRecordNumber,

        IsPrimaryContact;

      SQL SELECT *

      FROM METLABCORPORATION.Contacts

      WHERE Not WildMatch(FirstName,'ACCT*');