I have a table called VHS_Metadata_Aug52014
with columns:
Title, Description,Tag, Speaker, VIP, FilmingLocation, Notes
I'm trying to write a query that returns all records for which the word "News"
is not in any value. There are indeed records of this type. However, the query below returns nothing. So, I'm guessing I'm not quite understanding how to do it. I'm using MS Access, where the wildcard is *
.
UPDATE: I just tried also using the syntax:
Not VHS_Metadata_Aug52014!Description like '*News*'
And I'm still getting no hits.
select * from VHS_Metadata_Aug52014 where (
VHS_Metadata_Aug52014!Title Not like '*' & 'News' & '*'
And
VHS_Metadata_Aug52014!Description Not like '*' & 'News' & '*'
And
VHS_Metadata_Aug52014!Tag Not like '*' & 'News' & '*'
And
VHS_Metadata_Aug52014!Speaker Not like '*' & 'News' & '*'
And
VHS_Metadata_Aug52014!VIP Not like '*' & 'News' & '*'
And
VHS_Metadata_Aug52014!FilmingLocation Not like '*' & 'News' & '*'
And
VHS_Metadata_Aug52014!Notes Not like '*' & 'News' & '*'
) ;
ms-access
tag.Not like '*' & 'News' & '*'
instead ofNot like '*News*'
?sql
notms-access
are you using an MS Access client to access a SQL Server database?!
between table and column name?