4 Replies Latest reply: Oct 3, 2014 9:53 PM by Kim Rørmark RSS

    Where filter using like and wildcard

        I have a list of Business Units 10100000, 10200100, 10200150, 1040000, etc.


      I want to pull data only for business units that start with 10200XXX.


      If I use the code below and I do where WWBusUnit = "10200100" it
      will return the WWCustomerIndustry for that one Business Unit. However if I try
      to use a wild card, it does not return any WWCustomerIndustry records.



      What is the appropriate syntax or method to do what I want?


      LOAD WWBusUnit,


      WWBusUnit Like '*10200*'