Thank you Eirikur for your reply, but your request for more information is way over my head. I am using an access database as a gallery for my work and I was hoping to remove the wildcard operators from my WHERE statement. At the moment when I search for keyword "figure" I also return "non figure" records

Thankyou

Paul m