SQL syntax correction
Posted on 2004-10-03
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?