Where Statement

[#1]

Hello,

I am trying to exclude certain data from a QVD and am having issues - thus far i have indicated in the where statement that i need the material number to be < and > a specific number. i have also indicated that the brand must = 'A' or 'B' or 'C'. Now i am trying to exclude a subcategory but it will not work for some reason. I have used both 'AND' and 'OR' - the spare parts fall within each brand, i just do not want to see spare parts.

Any ideas as to what i am missing?

Thanks for your help,

Parrish

[m_woolf]

Please provide your where clause.

[#3]

Where MATERIAL_NUMBER > 999999 and MATERIAL_NUMBER<10000000 and Brand='A' or Brand='B' or Brand='F' and Product <>'Spare Parts';

[maxgro]

from your description it should be

where

matnum > 10 and matnum <20

and match(brand, 'A', 'B', 'C')

and not match(subcat, 100)

[#5]

the and match worked but not the not match - after i closed the match function, i just went back to doing subcat<>'A' and that worked. thank you for the help

[Clever_Anjos]

Where MATERIAL_NUMBER > 999999 and MATERIAL_NUMBER<10000000

and Match(Brand,'A','B','F')

and Product <>'Spare Parts';

Be careful when mixing AND and OR

OR clauses are evaluated after AND clauses

True And False Or True // evaluates true