3 Replies Latest reply: Sep 30, 2014 1:04 AM by jagan mohan rao appala RSS

    Help with where clause

      I want to exclude certain values from a field in my table. Right now, I'm already using a where clause, " where Location equal like 'M*'

       

      But I also need another where clause that only brings in the bolded products but since 93UK is in california and not a 'MO' location. It also should not be brought in. What function could i use to do include two where clauses?

       

      Product, Location

      11LB, MO-11

      12JK, MO-12

      93UK, California

      BA193, Florida

      AB197, Louisiana

      LA102, Kentucky

        • Re: Help with where clause
          Jean-Pierre Bakhache

          Hi,

           

          What is the condition you're using to identify the products in bold ?

          You will need to use "and" so it considers both of these conditions for the same record in the where clause.

           

          Theoretically, if you have an additional flag that indicates a bold product, your code could look like this:

           

          Load Product, Location

          from  ...

          where Location like 'M*' AND Product_Bold = 1;

           

          If this doesn't answer the request, it would be helpful if you can clarify more.

          • Re: Help with where clause
            Prashant Sangle

            Hi,

             

            If you want to load only Those product whose location start with M

             

            then write

            Load *

            from tablename

            where wildmatch(Location,'M*')

             

            It will load only those location which started M or m

             

            If you want to apply any other condition then use And / Or Keyword as per requirement.

             

            Regards

            • Re: Help with where clause
              jagan mohan rao appala

              Hi,

               

              Try like this

               

              Load Product, Location

              from  ...

              where Location like 'M*' AND Match(Product, '11LB', '12JK', '93UK');


              Regards,

              Jagan.


              '