<div>
Try this:<br />
<br />
SELECT &nbsp; &nbsp; ProdNumber, KeyWords<br />
FROM &nbsp; &nbsp; &nbsp; &nbsp; dbo.Products<br />
WHERE &nbsp; &nbsp; CONTAINS(KeyWords, ' &quot;Kids_Sunglasses&quot; OR &quot;Kids Sunglasses&quot; AND NOT &quot;Sunglasses_Infants/Kids&quot; ')<br />
ORDER BY ProdNumber<br />

</div>


Try this:

SELECT     ProdNumber, KeyWords
FROM         dbo.Products
WHERE     CONTAINS(KeyWords, ' "Kids_Sunglasses" OR "Kids Sunglasses" AND NOT "Sunglasses_Infants/Kids" ')
ORDER BY ProdNumber


<div>
Thanks rafrancisco - however, it is still pulling rows that have 'Sunglasses_Infants/Kids' as well as one of the others ('Kids_Sunglasses' or &quot;Kids Sunglasses&quot;). &nbsp;Any other Ideas? &nbsp;Any questions I can answer to help?<br />
<br />
Thanks for trying!<br />
<br />
Saladart
</div>


Thanks rafrancisco - however, it is still pulling rows that have 'Sunglasses_Infants/Kids' as well as one of the others ('Kids_Sunglasses' or "Kids Sunglasses").  Any other Ideas?  Any questions I can answer to help?

Thanks for trying!

Saladart

<div>
That did it - not sure why, but it worked...<br />
<br />
Thanks for your assistance!<br />
<br />
Saladart
</div>


That did it - not sure why, but it worked...

Thanks for your assistance!

Saladart

<div>
<div class="content wysiwyg-content">
Is there a way to do a NOT CONTAINS query?<br />
<br />
I am trying the following but it is not giving me the results I am expecting.<br />
<br />
SELECT &nbsp; &nbsp; ProdNumber, KeyWords<br />
FROM &nbsp; &nbsp; &nbsp; &nbsp; dbo.Products<br />
WHERE &nbsp; &nbsp; CONTAINS(KeyWords, 'Kids_Sunglasses') OR<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CONTAINS(KeyWords, ' &quot;Kids Sunglasses&quot; ') AND (NOT CONTAINS(KeyWords, 'Sunglasses_Infants/Kids')<wbr />)<br />
ORDER BY ProdNumber<br />
<br />
What I am trying to accomplish:<br />
<br />
I want all rows by ProdNumber's and Keywords where the keywords field contains the words 'Kids_Sunglasses' or &quot;Kids Sunglasses&quot; but does not also contain the words 'Sunglasses_Infants/Kids'.<wbr /><br />
<br />
Thanks for your assistance!<br />
<br />
Saladart
</div>
</div>


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
FROM         dbo.Products
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!

Saladart

NOT CONTAINS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.