RE: How to NOT match on an exception list

SSC Guru

Points: 323504

April 8, 2013 at 12:24 pm

fantastic job providing the DDL and sample data!

I think in this case, you need to match partial strings, right?

you will want to join the tables together, but use a LIKE statement for the join criteria,(where you might be used to A.ID = B.ID

this seems to do what i think we are after:

SELECT Products.*

FROM Products

LEFT OUTER JOIN Exceptions

ON Exceptions.ProductDesc LIKE '%' + Products.ProductDesc + '%'

WHERE Exceptions.ProductDesc IS NULL

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!