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,
      WWCustomerIndustry

      FROM
      WWCustomerIndustry.qvd
      (
      qvd)

      Where
      WWBusUnit Like '*10200*'