rosebud289
Programmer
I have created a search box to search for keywords in a paragraph contained in a field within a table. Whenever I use SELECT... WHERE variable LIKE '%" &variable& "%', words containing the keywords appear. For example, if I search for the word "day", paragraphs containing words such as "today" and "tuesday" will appear. Being that I'm searching for a whole word within a paragraph, I have to use LIKE in the SELECT statement right? Unfortunately, it's displaying everything under the sun. How can I fix this problem? Thanks!!!