Is there a way to do a NOT CONTAINS query?
I am trying the following but it is not giving me the results I am expecting.
SELECT ProdNumber, KeyWords
WHERE CONTAINS(KeyWords, 'Kids_Sunglasses') OR
CONTAINS(KeyWords, ' "Kids Sunglasses" ') AND (NOT CONTAINS(KeyWords, 'Sunglasses_Infants/Kids'))
ORDER BY ProdNumber
What I am trying to accomplish:
I want all rows by ProdNumber's and Keywords where the keywords field contains the words 'Kids_Sunglasses' or "Kids Sunglasses" but does not also contain the words 'Sunglasses_Infants/Kids'.
Thanks for your assistance!