Query filter help needed

[robojeff]

I have a query where I am trying to filter out parts that have a description starting with "OBL" and "ALPHA" but for some reason I am not able to keep items like this from being displayed in the results of my query.

Here is the SQL for my query:

SELECT BOM.BCHLD AS Item, Typ.IDESC AS Description
FROM BOM INNER JOIN Typ ON BOM.BCHLD = Typ.IPROD
WHERE (((Typ.IDESC) Not Like ("OBL*"))) OR (((Typ.IDESC) Not Like ("ALPHA*")))
ORDER BY BOM.BCHLD;

This is a sample of some of the DESC fields that are output from my query:

OBL/ALPHA REV
ALPHA REV FOR DOC

What am I doing wrong?

Thanks

 

[PHV]

WHERE Typ.IDESC Not Like 'OBL*' AND Typ.IDESC Not Like 'ALPHA*'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886