like clause

Hi, I am trying to return results from an ACCESS database using ASP where all of the search terms are in one of the fields. The query I am using is: SELECT photos.photoid, photos.landscape FROM photos INNER JOIN tblKeywords ON photos.photoid = tblKeywords.photoid WHERE gwlad = true AND...