how do i exclude fields with certain characters

N

ns

I have a field containing titles of books. I want to exclude records that
contain the specific characters "AFE". Help
 
K

Klatuu

You don't give enough inforamation to give a specific answer, but if you mean
exclude all records that contain the value AFE in a query, it would be in the
Where clause of the query:
WHERE [FieldName] NOT LIKE "*AFE*"
 
Top