I have a form field named "searchfor" and I'm wanting to search an Access database (4 different fields) to see if that word exists. The user has the option to search for the word plainly, or to "match whole word". It's the "match whole word" that's getting me.<BR><BR>If I was searching for "Bob", and wanted "match whole word only" I would need to search for "Bob", " Bob ", " Bob", and "Bob " (I know there are many more combinations with punctuation, etc, but let's just leave it at these to begin with).<BR><BR>How can I do this using a query statement? I thought the following would work to find the word with spaces on either side of it:<BR><BR>ItemName Like ' " & Request.Form("searchfor") & " '<BR><BR>however it doesn't return any records when I do a search for a word I know exists in that field in that table. I even tried the word "and".<BR><BR>Help :) Thanks in advance.