<div>
<div class="content wysiwyg-content">
I have this sql statement which supposed goal is to select items based on the description field only if they do not have <br />
the word 'Not in&quot; or &nbsp;&quot;Discontinued&quot; in the beginning of the description field; s in<br />
<br />
&quot;&nbsp;Not in the list...&quot; or &quot;Discontinued item...&quot; and so forth<br />
<br />
SELECT Publisher,Book,Descrip,Cos<wbr />t, List,pubid,RowLastUpDtByOp<wbr />,RowLastUp<wbr />dtDtTi from Books where pubid = '276 ' and(descrip not like 'Not%' or descrip not like 'Discontinued %') order by id <br />
<br />
For some reason I still get those data that has 'Not in&quot; or &quot;Discontinued' in the resultset.<br />
Where am I making the mistakes?<br />
<br />

</div>
</div>


I have this sql statement which supposed goal is to select items based on the description field only if they do not have 
the word 'Not in" or  "Discontinued" in the beginning of the description field; s in

" Not in the list..." or "Discontinued item..." and so forth

SELECT Publisher,Book,Descrip,Cost, List,pubid,RowLastUpDtByOp,RowLastUpdtDtTi from Books where pubid = '276 ' and(descrip not like 'Not%' or descrip not like 'Discontinued %') order by id 

For some reason I still get those data that has 'Not in" or "Discontinued' in the resultset.
Where am I making the mistakes?



SQL syntax correction

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.